CREDIT CARD SPEND PREDICTION¶
In [1]:
## Importing the libraries
import numpy as np
import matplotlib.pyplot as plt
import pandas as pd
import seaborn as sns
import warnings
warnings.filterwarnings('ignore')
%matplotlib inline
plt.rcParams["patch.force_edgecolor"]=True
In [2]:
# Importing the data dictionary
data_dictionary = pd.read_excel('CREDIT CARD USERS DATA.xlsx',sheet_name=None)
In [3]:
data_dictionary
Out[3]:
In [4]:
data_dictionary.keys()
Out[4]:
In [5]:
data_dictionary['Business Problem']
Out[5]:
In [6]:
data_dictionary['Business Problem']['Unnamed: 1'][1]
Out[6]:
In [7]:
data_dictionary['Data Dictionary']
Out[7]:
In [8]:
num_var = dict(zip(data_dictionary['Data Dictionary']['Numeric Variable'],data_dictionary['Data Dictionary']['Numeric Variable']))
In [9]:
num_var
Out[9]:
In [10]:
dataset=data_dictionary['customer_dbase']
In [11]:
dataset.head()
Out[11]:
In [12]:
# Removing custid, birthmonth column
dataset = dataset.drop(['custid', 'birthmonth'], axis = 1)
In [13]:
def var_summary(x):
return pd.Series([(x.isnull().sum()/len(x))*100, x.dtype, len(x.dropna().unique()), len(x), x.count(), x.isnull().sum(), x.sum(), x.dropna().mean(), x.dropna().median(), x.dropna().std(), x.dropna().var(), x.min(), x.dropna().quantile(0.01), x.dropna().quantile(0.05),x.dropna().quantile(0.10),x.dropna().quantile(0.25),x.dropna().quantile(0.50),x.dropna().quantile(0.75), x.dropna().quantile(0.90),x.dropna().quantile(0.95), x.dropna().quantile(0.99),x.max(), (x.dropna().quantile(0.75) - x.dropna().quantile(0.25)), (x.dropna().mean()+3*(x.dropna().std())), (x.dropna().mean()-3*(x.dropna().std())), (x.dropna().quantile(0.25)-(1.5*(x.dropna().quantile(0.75) - x.dropna().quantile(0.25)))), (x.dropna().quantile(0.75)+(1.5*(x.dropna().quantile(0.75) - x.dropna().quantile(0.25)))), ((x.max() > x.dropna().mean()+3*x.dropna().std()) | (x.min() < x.dropna().mean()-3*x.dropna().std())), ((x.max() > x.dropna().quantile(0.75)+(1.5*(x.dropna().quantile(0.75) - x.dropna().quantile(0.25)))) | (x.min() < x.dropna().quantile(0.25)-(1.5*(x.dropna().quantile(0.75) - x.dropna().quantile(0.25)))))] ,
index=['NMISS%', 'D-type', 'unique', 'Length', 'N', 'NMISS', 'SUM', 'MEAN','MEDIAN', 'STD', 'VAR', 'MIN', 'P1' , 'P5' ,'P10(Q1)' ,'P25' ,'P50(Q2)', 'P75(Q3)' ,'P90' ,'P95' ,'P99' ,'MAX', 'IQR', '+3std', '-3std', 'lowerB', 'upperB', 'outlier 1', 'outlier 2'])
dataset.apply(lambda x: var_summary(x)).T
Out[13]:
In [14]:
dataset.isnull().sum()[dataset.isnull().sum()>0]
Out[14]:
In [15]:
dataset.commutetime.fillna(dataset.commutetime.mean(),inplace=True)
di={1: 1, 5: 5}
dataset.townsize.fillna(dataset.region.map(di),inplace=True)
dataset.cardten.fillna(dataset.cardten.mean(),inplace=True)
dataset.longten.fillna(dataset.longten.mean(),inplace=True)
In [16]:
dataset['lncreddebt'] = np.log(dataset.creddebt+1)
dataset['lnothdebt'] = np.log(dataset.othdebt+1)
dataset['lnlongten'] = np.log(dataset.longten+1)
dataset['lntollmon'] = np.log(dataset.tollmon+1)
dataset['lnequipmon'] = np.log(dataset.equipmon+1)
dataset['lntollten'] = np.log(dataset.tollten+1)
dataset['lnequipten'] = np.log(dataset.equipten+1)
dataset['lncardmon'] = np.log(dataset.cardmon+1)
dataset['lncardten'] = np.log(dataset.cardten+1)
dataset['lnwiremon'] = np.log(dataset.wiremon+1)
dataset['lnwireten'] = np.log(dataset.wireten+1)
In [17]:
dataset.isnull().sum()[dataset.isnull().sum()>0]
Out[17]:
In [18]:
dataset.isnull().sum().sum()
Out[18]:
In [19]:
dataset.apply(lambda x: var_summary(x)).T
Out[19]:
Outlier Removing by Clipping¶
In [20]:
dataset=dataset.apply(lambda x:x.clip(x.quantile(0.01),x.quantile(0.99)))
In [21]:
dataset['total_spent']=dataset['cardspent']+dataset['card2spent']
In [22]:
dataset.drop(['cardspent','card2spent'],inplace=True,axis=1)
In [23]:
dataset.total_spent.hist()
Out[23]:
the 'total spent' is not in normal form transform it to normal form by taking its log
In [24]:
dataset['total_spent']=np.log(dataset['total_spent'])
In [25]:
dataset['total_spent'].hist()
Out[25]:
In [26]:
binary = dataset.apply(lambda x: len(x.unique()) )[dataset.apply(lambda x: len(x.unique()) ) == 2].index
In [27]:
binary
Out[27]:
Removing all the columns that have only 2 possible values¶
In [28]:
df=dataset.drop(binary,axis=1)
In [29]:
warnings.filterwarnings('ignore')
for i in range(len(df.columns)):
sns.set(rc={'figure.figsize':(11.7,5)})
plt.subplot(len(df.columns), 1, 1)
p=sns.jointplot(df.iloc[:,i],'total_spent',df)
In [30]:
dataset.corr().iloc[:,-1:]
Out[30]:
In [31]:
num_var.keys()
Out[31]:
As we can see that here we have 2 cards and same columns for each card. So we cam combine those columns
In [32]:
dataset['total_benefit']=dataset['cardbenefit']+dataset['card2benefit']
dataset['total_fee']=dataset['cardfee']+dataset['card2fee']
dataset['total_tenure']=dataset['cardtenure']+dataset['card2tenure']
dataset['total_items']=dataset['carditems']+dataset['card2items']
In [33]:
dataset.drop(['cardbenefit','card2benefit','carditems','card2items','cardtenure','card2tenure','cardfee','card2fee'],axis=1,inplace=True)
Main Assumptions for multiple Regression¶
1>Normality:
relation between X and Y should be linear
check using
a)QQ Plot
b)Histogram of Residuals
2>No Multicollinearity:
Variables having high Correlation
correction:
Drop variables with high correlation
3>No Autocorrelation
Residuals correlated with one another
check using:
a)scatterplot
correction:
Adjust the coeff std error using transformation
4>Heteroscadasticity
Variance increase with increase in X
check using
a)Scatterplot
correction:
Calc robust Std error to recalc T-statsProfiling¶
In [34]:
import statsmodels.formula.api as smf
all_columns = "+".join(dataset.columns.difference( ['total_spent'] ))
In [35]:
formula='total_spent~'+all_columns
In [36]:
lm=smf.ols(formula=formula,data=dataset).fit()
In [37]:
lm.summary()
Out[37]:
Doing a ProfileReport to get a overview¶
In [38]:
warnings.filterwarnings('ignore')
import pandas_profiling
In [39]:
profile= pandas_profiling.ProfileReport(dataset)
In [40]:
profile
Out[40]:
Overview
Dataset info
| Number of variables | 125 |
|---|---|
| Number of observations | 5000 |
| Total Missing (%) | 0.0% |
| Total size in memory | 4.8 MiB |
| Average record size in memory | 1000.0 B |
Variables types
| Numeric | 54 |
|---|---|
| Categorical | 0 |
| Boolean | 47 |
| Date | 0 |
| Text (Unique) | 0 |
| Rejected | 24 |
| Unsupported | 0 |
Warnings
addresshas 245 / 4.9% zeros Zerosaddresscatis highly correlated withaddress(ρ = 0.92717) Rejectedagecatis highly correlated withage(ρ = 0.96988) Rejectedcarboughthas 2901 / 58.0% zeros Zeroscard2tenurecatis highly correlated withcardtenurecat(ρ = 0.92431) Rejectedcardmonhas 1419 / 28.4% zeros Zeroscardtenhas 1420 / 28.4% zeros Zeroscarownhas 799 / 16.0% zeros Zeroscarshas 497 / 9.9% zeros Zeroscartypehas 2287 / 45.7% zeros Zeroscommutecatis highly correlated withcommute(ρ = 0.98117) Rejectededcatis highly correlated withed(ρ = 0.96649) Rejectedempcatis highly correlated withemploy(ρ = 0.90359) Rejectedemployhas 659 / 13.2% zeros Zerosequipmonis highly correlated withequip(ρ = 0.94719) Rejectedequiptenhas 3296 / 65.9% zeros Zeroshourstvhas 85 / 1.7% zeros Zerosinccatis highly correlated withlninc(ρ = 0.95154) Rejectedinternethas 2498 / 50.0% zeros Zeroslncardmonis highly correlated withcallcard(ρ = 0.94918) Rejectedlncardtenis highly correlated withlncardmon(ρ = 0.96006) Rejectedlncreddebtis highly correlated withcreddebt(ρ = 0.92026) Rejectedlnequipmonis highly correlated withequipmon(ρ = 0.97195) Rejectedlnequiptenis highly correlated withlnequipmon(ρ = 0.98331) Rejectedlnlongtenis highly correlated withlnlongmon(ρ = 0.92481) Rejectedlnothdebtis highly correlated withothdebt(ρ = 0.90163) Rejectedlntollmonis highly correlated withtollmon(ρ = 0.93703) Rejectedlntolltenis highly correlated withlntollmon(ρ = 0.98558) Rejectedlnwiremonis highly correlated withwiremon(ρ = 0.95325) Rejectedlnwiretenis highly correlated withlnwiremon(ρ = 0.98726) Rejectedlongtenis highly correlated withlongmon(ρ = 0.98281) Rejectedpetshas 1529 / 30.6% zeros Zerospets_birdshas 4698 / 94.0% zeros Zerospets_catshas 3413 / 68.3% zeros Zerospets_dogshas 3762 / 75.2% zeros Zerospets_freshfishhas 3462 / 69.2% zeros Zerospets_reptileshas 4818 / 96.4% zeros Zerospets_saltfishhas 4942 / 98.8% zeros Zerospets_smallhas 4749 / 95.0% zeros Zerosspousedis highly correlated withmarital(ρ = 0.95763) Rejectedspousedcatis highly correlated withspoused(ρ = 0.98315) Rejectedtollmonhas 2622 / 52.4% zeros Zerostolltenhas 2622 / 52.4% zeros Zerostotal_feehas 3294 / 65.9% zeros Zerostotal_tenureis highly correlated withtenure(ρ = 0.92561) Rejectedwiremonis highly correlated withwireless(ρ = 0.91316) Rejectedwiretenhas 3656 / 73.1% zeros Zeros
Variables
active
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.466 |
|---|
| 0.0 | |
|---|---|
| 1.0 |
| Value | Count | Frequency (%) | |
| 0.0 | 2670 | 53.4% | |
| 1.0 | 2330 | 46.6% |
address
Numeric
| Distinct count | 49 |
|---|---|
| Unique (%) | 1.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 16.366 |
|---|---|
| Minimum | 0 |
| Maximum | 48 |
| Zeros (%) | 4.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 6 |
| Median | 14 |
| Q3 | 25 |
| 95-th percentile | 40 |
| Maximum | 48 |
| Range | 48 |
| Interquartile range | 19 |
Descriptive statistics
| Standard deviation | 12.298 |
|---|---|
| Coef of variation | 0.75141 |
| Kurtosis | -0.38457 |
| Mean | 16.366 |
| MAD | 10.183 |
| Skewness | 0.66468 |
| Sum | 81832 |
| Variance | 151.24 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 0.0 | 245 | 4.9% | |
| 2.0 | 196 | 3.9% | |
| 4.0 | 195 | 3.9% | |
| 5.0 | 177 | 3.5% | |
| 3.0 | 172 | 3.4% | |
| 8.0 | 169 | 3.4% | |
| 1.0 | 169 | 3.4% | |
| 7.0 | 166 | 3.3% | |
| 12.0 | 166 | 3.3% | |
| 6.0 | 163 | 3.3% | |
| Other values (39) | 3182 | 63.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.0 | 245 | 4.9% | |
| 1.0 | 169 | 3.4% | |
| 2.0 | 196 | 3.9% | |
| 3.0 | 172 | 3.4% | |
| 4.0 | 195 | 3.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 44.0 | 27 | 0.5% | |
| 45.0 | 23 | 0.5% | |
| 46.0 | 17 | 0.3% | |
| 47.0 | 18 | 0.4% | |
| 48.0 | 70 | 1.4% |
addresscat
Highly correlated
This variable is highly correlated with address and should be ignored for analysis
| Correlation | 0.92717 |
|---|
age
Numeric
| Distinct count | 62 |
|---|---|
| Unique (%) | 1.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 47.026 |
|---|---|
| Minimum | 18 |
| Maximum | 79 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 18 |
|---|---|
| 5-th percentile | 20 |
| Q1 | 31 |
| Median | 47 |
| Q3 | 62 |
| 95-th percentile | 76 |
| Maximum | 79 |
| Range | 61 |
| Interquartile range | 31 |
Descriptive statistics
| Standard deviation | 17.77 |
|---|---|
| Coef of variation | 0.37789 |
| Kurtosis | -1.187 |
| Mean | 47.026 |
| MAD | 15.403 |
| Skewness | 0.09076 |
| Sum | 235130 |
| Variance | 315.78 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 18.0 | 106 | 2.1% | |
| 35.0 | 102 | 2.0% | |
| 37.0 | 98 | 2.0% | |
| 24.0 | 97 | 1.9% | |
| 63.0 | 95 | 1.9% | |
| 21.0 | 95 | 1.9% | |
| 31.0 | 94 | 1.9% | |
| 25.0 | 93 | 1.9% | |
| 57.0 | 93 | 1.9% | |
| 36.0 | 92 | 1.8% | |
| Other values (52) | 4035 | 80.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 18.0 | 106 | 2.1% | |
| 19.0 | 78 | 1.6% | |
| 20.0 | 80 | 1.6% | |
| 21.0 | 95 | 1.9% | |
| 22.0 | 82 | 1.6% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 75.0 | 74 | 1.5% | |
| 76.0 | 58 | 1.2% | |
| 77.0 | 71 | 1.4% | |
| 78.0 | 70 | 1.4% | |
| 79.0 | 73 | 1.5% |
agecat
Highly correlated
This variable is highly correlated with age and should be ignored for analysis
| Correlation | 0.96988 |
|---|
bfast
Numeric
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.0586 |
|---|---|
| Minimum | 1 |
| Maximum | 3 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 2 |
| Q3 | 3 |
| 95-th percentile | 3 |
| Maximum | 3 |
| Range | 2 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 0.82952 |
|---|---|
| Coef of variation | 0.40295 |
| Kurtosis | -1.5385 |
| Mean | 2.0586 |
| MAD | 0.70605 |
| Skewness | -0.10964 |
| Sum | 10293 |
| Variance | 0.6881 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 3.0 | 1875 | 37.5% | |
| 1.0 | 1582 | 31.6% | |
| 2.0 | 1543 | 30.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.0 | 1582 | 31.6% | |
| 2.0 | 1543 | 30.9% | |
| 3.0 | 1875 | 37.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.0 | 1582 | 31.6% | |
| 2.0 | 1543 | 30.9% | |
| 3.0 | 1875 | 37.5% |
callcard
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.7162 |
|---|
| 1.0 | |
|---|---|
| 0.0 |
| Value | Count | Frequency (%) | |
| 1.0 | 3581 | 71.6% | |
| 0.0 | 1419 | 28.4% |
callid
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.4752 |
|---|
| 0.0 | |
|---|---|
| 1.0 |
| Value | Count | Frequency (%) | |
| 0.0 | 2624 | 52.5% | |
| 1.0 | 2376 | 47.5% |
callwait
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.479 |
|---|
| 0.0 | |
|---|---|
| 1.0 |
| Value | Count | Frequency (%) | |
| 0.0 | 2605 | 52.1% | |
| 1.0 | 2395 | 47.9% |
carbought
Numeric
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.221 |
|---|---|
| Minimum | -1 |
| Maximum | 1 |
| Zeros (%) | 58.0% |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | -1 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 2 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 0.60912 |
|---|---|
| Coef of variation | 2.7562 |
| Kurtosis | -0.5264 |
| Mean | 0.221 |
| MAD | 0.49918 |
| Skewness | -0.15823 |
| Sum | 1105 |
| Variance | 0.37103 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 0.0 | 2901 | 58.0% | |
| 1.0 | 1602 | 32.0% | |
| -1.0 | 497 | 9.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -1.0 | 497 | 9.9% | |
| 0.0 | 2901 | 58.0% | |
| 1.0 | 1602 | 32.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| -1.0 | 497 | 9.9% | |
| 0.0 | 2901 | 58.0% | |
| 1.0 | 1602 | 32.0% |
carbuy
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.361 |
|---|
| 0.0 | |
|---|---|
| 1.0 |
| Value | Count | Frequency (%) | |
| 0.0 | 3195 | 63.9% | |
| 1.0 | 1805 | 36.1% |
carcatvalue
Numeric
| Distinct count | 4 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.3894 |
|---|---|
| Minimum | -1 |
| Maximum | 3 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | -1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 3 |
| Range | 4 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 1.0813 |
|---|---|
| Coef of variation | 0.77825 |
| Kurtosis | 0.23064 |
| Mean | 1.3894 |
| MAD | 0.84868 |
| Skewness | -0.49643 |
| Sum | 6947 |
| Variance | 1.1692 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 1.0 | 2399 | 48.0% | |
| 2.0 | 1267 | 25.3% | |
| 3.0 | 837 | 16.7% | |
| -1.0 | 497 | 9.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -1.0 | 497 | 9.9% | |
| 1.0 | 2399 | 48.0% | |
| 2.0 | 1267 | 25.3% | |
| 3.0 | 837 | 16.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| -1.0 | 497 | 9.9% | |
| 1.0 | 2399 | 48.0% | |
| 2.0 | 1267 | 25.3% | |
| 3.0 | 837 | 16.7% |
card
Numeric
| Distinct count | 5 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.7142 |
|---|---|
| Minimum | 1 |
| Maximum | 5 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| Median | 3 |
| Q3 | 4 |
| 95-th percentile | 4 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 1.1849 |
|---|---|
| Coef of variation | 0.43656 |
| Kurtosis | -1.1112 |
| Mean | 2.7142 |
| MAD | 1.0323 |
| Skewness | 0.015333 |
| Sum | 13571 |
| Variance | 1.404 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 4.0 | 1344 | 26.9% | |
| 2.0 | 1247 | 24.9% | |
| 3.0 | 1200 | 24.0% | |
| 1.0 | 986 | 19.7% | |
| 5.0 | 223 | 4.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.0 | 986 | 19.7% | |
| 2.0 | 1247 | 24.9% | |
| 3.0 | 1200 | 24.0% | |
| 4.0 | 1344 | 26.9% | |
| 5.0 | 223 | 4.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.0 | 986 | 19.7% | |
| 2.0 | 1247 | 24.9% | |
| 3.0 | 1200 | 24.0% | |
| 4.0 | 1344 | 26.9% | |
| 5.0 | 223 | 4.5% |
card2
Numeric
| Distinct count | 5 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.7744 |
|---|---|
| Minimum | 1 |
| Maximum | 5 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| Median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 1.1734 |
|---|---|
| Coef of variation | 0.42296 |
| Kurtosis | -0.91791 |
| Mean | 2.7744 |
| MAD | 0.99139 |
| Skewness | 0.084736 |
| Sum | 13872 |
| Variance | 1.377 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 3.0 | 1384 | 27.7% | |
| 2.0 | 1301 | 26.0% | |
| 4.0 | 1141 | 22.8% | |
| 1.0 | 829 | 16.6% | |
| 5.0 | 345 | 6.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.0 | 829 | 16.6% | |
| 2.0 | 1301 | 26.0% | |
| 3.0 | 1384 | 27.7% | |
| 4.0 | 1141 | 22.8% | |
| 5.0 | 345 | 6.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.0 | 829 | 16.6% | |
| 2.0 | 1301 | 26.0% | |
| 3.0 | 1384 | 27.7% | |
| 4.0 | 1141 | 22.8% | |
| 5.0 | 345 | 6.9% |
card2tenurecat
Highly correlated
This variable is highly correlated with cardtenurecat and should be ignored for analysis
| Correlation | 0.92431 |
|---|
card2type
Numeric
| Distinct count | 4 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.5412 |
|---|---|
| Minimum | 1 |
| Maximum | 4 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| Median | 3 |
| Q3 | 4 |
| 95-th percentile | 4 |
| Maximum | 4 |
| Range | 3 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 1.1188 |
|---|---|
| Coef of variation | 0.44027 |
| Kurtosis | -1.3601 |
| Mean | 2.5412 |
| MAD | 1.0003 |
| Skewness | -0.04748 |
| Sum | 12706 |
| Variance | 1.2518 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 4.0 | 1319 | 26.4% | |
| 3.0 | 1257 | 25.1% | |
| 2.0 | 1235 | 24.7% | |
| 1.0 | 1189 | 23.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.0 | 1189 | 23.8% | |
| 2.0 | 1235 | 24.7% | |
| 3.0 | 1257 | 25.1% | |
| 4.0 | 1319 | 26.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.0 | 1189 | 23.8% | |
| 2.0 | 1235 | 24.7% | |
| 3.0 | 1257 | 25.1% | |
| 4.0 | 1319 | 26.4% |
cardmon
Numeric
| Distinct count | 229 |
|---|---|
| Unique (%) | 4.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 15.267 |
|---|---|
| Minimum | 0 |
| Maximum | 64.25 |
| Zeros (%) | 28.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 13.75 |
| Q3 | 22.75 |
| 95-th percentile | 42 |
| Maximum | 64.25 |
| Range | 64.25 |
| Interquartile range | 22.75 |
Descriptive statistics
| Standard deviation | 14.156 |
|---|---|
| Coef of variation | 0.92725 |
| Kurtosis | 1.022 |
| Mean | 15.267 |
| MAD | 11.048 |
| Skewness | 1.0164 |
| Sum | 76335 |
| Variance | 200.4 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 0.0 | 1419 | 28.4% | |
| 13.25 | 53 | 1.1% | |
| 11.5 | 52 | 1.0% | |
| 64.25 | 51 | 1.0% | |
| 16.25 | 49 | 1.0% | |
| 16.5 | 49 | 1.0% | |
| 13.75 | 47 | 0.9% | |
| 18.25 | 45 | 0.9% | |
| 13.5 | 45 | 0.9% | |
| 15.0 | 44 | 0.9% | |
| Other values (219) | 3146 | 62.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.0 | 1419 | 28.4% | |
| 3.25 | 1 | 0.0% | |
| 3.75 | 1 | 0.0% | |
| 4.0 | 3 | 0.1% | |
| 4.25 | 9 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 63.25 | 1 | 0.0% | |
| 63.5 | 1 | 0.0% | |
| 63.75 | 1 | 0.0% | |
| 64.0 | 2 | 0.0% | |
| 64.25 | 51 | 1.0% |
cardten
Numeric
| Distinct count | 651 |
|---|---|
| Unique (%) | 13.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 707.24 |
|---|---|
| Minimum | 0 |
| Maximum | 4010.4 |
| Zeros (%) | 28.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 425 |
| Q3 | 1080 |
| 95-th percentile | 2455.3 |
| Maximum | 4010.4 |
| Range | 4010.4 |
| Interquartile range | 1080 |
Descriptive statistics
| Standard deviation | 848.14 |
|---|---|
| Coef of variation | 1.1992 |
| Kurtosis | 2.6283 |
| Mean | 707.24 |
| MAD | 650.61 |
| Skewness | 1.6086 |
| Sum | 3536200 |
| Variance | 719340 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 0.0 | 1420 | 28.4% | |
| 4010.4000000000087 | 50 | 1.0% | |
| 590.0 | 21 | 0.4% | |
| 200.0 | 20 | 0.4% | |
| 380.0 | 20 | 0.4% | |
| 195.0 | 19 | 0.4% | |
| 45.0 | 19 | 0.4% | |
| 500.0 | 19 | 0.4% | |
| 220.0 | 18 | 0.4% | |
| 330.0 | 18 | 0.4% | |
| Other values (641) | 3376 | 67.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.0 | 1420 | 28.4% | |
| 4.75 | 1 | 0.0% | |
| 5.0 | 17 | 0.3% | |
| 5.25 | 1 | 0.0% | |
| 7.75 | 1 | 0.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3960.0 | 1 | 0.0% | |
| 3980.0 | 1 | 0.0% | |
| 4000.0 | 1 | 0.0% | |
| 4010.0 | 1 | 0.0% | |
| 4010.4000000000087 | 50 | 1.0% |
cardtenurecat
Numeric
| Distinct count | 5 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.7822 |
|---|---|
| Minimum | 1 |
| Maximum | 5 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| Median | 4 |
| Q3 | 5 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 1.3538 |
|---|---|
| Coef of variation | 0.35794 |
| Kurtosis | -1.0266 |
| Mean | 3.7822 |
| MAD | 1.2057 |
| Skewness | -0.62824 |
| Sum | 18911 |
| Variance | 1.8327 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 5.0 | 2351 | 47.0% | |
| 2.0 | 847 | 16.9% | |
| 3.0 | 789 | 15.8% | |
| 4.0 | 694 | 13.9% | |
| 1.0 | 319 | 6.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.0 | 319 | 6.4% | |
| 2.0 | 847 | 16.9% | |
| 3.0 | 789 | 15.8% | |
| 4.0 | 694 | 13.9% | |
| 5.0 | 2351 | 47.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.0 | 319 | 6.4% | |
| 2.0 | 847 | 16.9% | |
| 3.0 | 789 | 15.8% | |
| 4.0 | 694 | 13.9% | |
| 5.0 | 2351 | 47.0% |
cardtype
Numeric
| Distinct count | 4 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.507 |
|---|---|
| Minimum | 1 |
| Maximum | 4 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| Median | 3 |
| Q3 | 4 |
| 95-th percentile | 4 |
| Maximum | 4 |
| Range | 3 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 1.1185 |
|---|---|
| Coef of variation | 0.44614 |
| Kurtosis | -1.3608 |
| Mean | 2.507 |
| MAD | 1.0004 |
| Skewness | -0.0098086 |
| Sum | 12535 |
| Variance | 1.251 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 4.0 | 1260 | 25.2% | |
| 3.0 | 1257 | 25.1% | |
| 1.0 | 1242 | 24.8% | |
| 2.0 | 1241 | 24.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.0 | 1242 | 24.8% | |
| 2.0 | 1241 | 24.8% | |
| 3.0 | 1257 | 25.1% | |
| 4.0 | 1260 | 25.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.0 | 1242 | 24.8% | |
| 2.0 | 1241 | 24.8% | |
| 3.0 | 1257 | 25.1% | |
| 4.0 | 1260 | 25.2% |
carown
Numeric
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.6414 |
|---|---|
| Minimum | -1 |
| Maximum | 1 |
| Zeros (%) | 16.0% |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | -1 |
| Q1 | 0 |
| Median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 2 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 0.6549 |
|---|---|
| Coef of variation | 1.021 |
| Kurtosis | 1.14 |
| Mean | 0.6414 |
| MAD | 0.5313 |
| Skewness | -1.5944 |
| Sum | 3207 |
| Variance | 0.42889 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 1.0 | 3704 | 74.1% | |
| 0.0 | 799 | 16.0% | |
| -1.0 | 497 | 9.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -1.0 | 497 | 9.9% | |
| 0.0 | 799 | 16.0% | |
| 1.0 | 3704 | 74.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| -1.0 | 497 | 9.9% | |
| 0.0 | 799 | 16.0% | |
| 1.0 | 3704 | 74.1% |
cars
Numeric
| Distinct count | 7 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.1276 |
|---|---|
| Minimum | 0 |
| Maximum | 6 |
| Zeros (%) | 9.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| Median | 2 |
| Q3 | 3 |
| 95-th percentile | 4 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 1.2972 |
|---|---|
| Coef of variation | 0.60972 |
| Kurtosis | 0.059786 |
| Mean | 2.1276 |
| MAD | 1.0097 |
| Skewness | 0.43884 |
| Sum | 10638 |
| Variance | 1.6829 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 2.0 | 1607 | 32.1% | |
| 1.0 | 1119 | 22.4% | |
| 3.0 | 1082 | 21.6% | |
| 0.0 | 497 | 9.9% | |
| 4.0 | 481 | 9.6% | |
| 5.0 | 149 | 3.0% | |
| 6.0 | 65 | 1.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.0 | 497 | 9.9% | |
| 1.0 | 1119 | 22.4% | |
| 2.0 | 1607 | 32.1% | |
| 3.0 | 1082 | 21.6% | |
| 4.0 | 481 | 9.6% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2.0 | 1607 | 32.1% | |
| 3.0 | 1082 | 21.6% | |
| 4.0 | 481 | 9.6% | |
| 5.0 | 149 | 3.0% | |
| 6.0 | 65 | 1.3% |
cartype
Numeric
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.3438 |
|---|---|
| Minimum | -1 |
| Maximum | 1 |
| Zeros (%) | 45.7% |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | -1 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 2 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 0.65153 |
|---|---|
| Coef of variation | 1.8951 |
| Kurtosis | -0.70821 |
| Mean | 0.3438 |
| MAD | 0.58166 |
| Skewness | -0.48685 |
| Sum | 1719 |
| Variance | 0.42449 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 0.0 | 2287 | 45.7% | |
| 1.0 | 2216 | 44.3% | |
| -1.0 | 497 | 9.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -1.0 | 497 | 9.9% | |
| 0.0 | 2287 | 45.7% | |
| 1.0 | 2216 | 44.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| -1.0 | 497 | 9.9% | |
| 0.0 | 2287 | 45.7% | |
| 1.0 | 2216 | 44.3% |
carvalue
Numeric
| Distinct count | 767 |
|---|---|
| Unique (%) | 15.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 23.202 |
|---|---|
| Minimum | -1 |
| Maximum | 92.001 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | -1 |
| Q1 | 9.2 |
| Median | 17 |
| Q3 | 31.1 |
| 95-th percentile | 72 |
| Maximum | 92.001 |
| Range | 93.001 |
| Interquartile range | 21.9 |
Descriptive statistics
| Standard deviation | 21.13 |
|---|---|
| Coef of variation | 0.91068 |
| Kurtosis | 1.8374 |
| Mean | 23.202 |
| MAD | 15.866 |
| Skewness | 1.451 |
| Sum | 116010 |
| Variance | 446.47 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| -1.0 | 497 | 9.9% | |
| 92.00100000000002 | 50 | 1.0% | |
| 9.8 | 25 | 0.5% | |
| 13.5 | 24 | 0.5% | |
| 6.300000000000001 | 24 | 0.5% | |
| 10.200000000000001 | 23 | 0.5% | |
| 13.0 | 23 | 0.5% | |
| 15.8 | 22 | 0.4% | |
| 9.200000000000001 | 22 | 0.4% | |
| 9.1 | 22 | 0.4% | |
| Other values (757) | 4268 | 85.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -1.0 | 497 | 9.9% | |
| 2.2 | 1 | 0.0% | |
| 2.3000000000000003 | 1 | 0.0% | |
| 2.4000000000000004 | 1 | 0.0% | |
| 2.5 | 1 | 0.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 91.7 | 1 | 0.0% | |
| 91.80000000000001 | 1 | 0.0% | |
| 91.9 | 1 | 0.0% | |
| 92.0 | 1 | 0.0% | |
| 92.00100000000002 | 50 | 1.0% |
churn
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.2532 |
|---|
| 0.0 | |
|---|---|
| 1.0 |
| Value | Count | Frequency (%) | |
| 0.0 | 3734 | 74.7% | |
| 1.0 | 1266 | 25.3% |
commute
Numeric
| Distinct count | 10 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.9962 |
|---|---|
| Minimum | 1 |
| Maximum | 10 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 4 |
| 95-th percentile | 8 |
| Maximum | 10 |
| Range | 9 |
| Interquartile range | 3 |
Descriptive statistics
| Standard deviation | 2.7435 |
|---|---|
| Coef of variation | 0.91567 |
| Kurtosis | -0.045572 |
| Mean | 2.9962 |
| MAD | 2.2996 |
| Skewness | 1.1277 |
| Sum | 14981 |
| Variance | 7.5269 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 1.0 | 2855 | 57.1% | |
| 4.0 | 635 | 12.7% | |
| 8.0 | 585 | 11.7% | |
| 5.0 | 302 | 6.0% | |
| 3.0 | 295 | 5.9% | |
| 10.0 | 153 | 3.1% | |
| 7.0 | 56 | 1.1% | |
| 2.0 | 50 | 1.0% | |
| 6.0 | 44 | 0.9% | |
| 9.0 | 25 | 0.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.0 | 2855 | 57.1% | |
| 2.0 | 50 | 1.0% | |
| 3.0 | 295 | 5.9% | |
| 4.0 | 635 | 12.7% | |
| 5.0 | 302 | 6.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 6.0 | 44 | 0.9% | |
| 7.0 | 56 | 1.1% | |
| 8.0 | 585 | 11.7% | |
| 9.0 | 25 | 0.5% | |
| 10.0 | 153 | 3.1% |
commutebike
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.1234 |
|---|
| 0.0 | |
|---|---|
| 1.0 | 617 |
| Value | Count | Frequency (%) | |
| 0.0 | 4383 | 87.7% | |
| 1.0 | 617 | 12.3% |
commutebus
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.406 |
|---|
| 0.0 | |
|---|---|
| 1.0 |
| Value | Count | Frequency (%) | |
| 0.0 | 2970 | 59.4% | |
| 1.0 | 2030 | 40.6% |
commutecar
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.679 |
|---|
| 1.0 | |
|---|---|
| 0.0 |
| Value | Count | Frequency (%) | |
| 1.0 | 3395 | 67.9% | |
| 0.0 | 1605 | 32.1% |
commutecarpool
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.2718 |
|---|
| 0.0 | |
|---|---|
| 1.0 |
| Value | Count | Frequency (%) | |
| 0.0 | 3641 | 72.8% | |
| 1.0 | 1359 | 27.2% |
commutecat
Highly correlated
This variable is highly correlated with commute and should be ignored for analysis
| Correlation | 0.98117 |
|---|
commutemotorcycle
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.1026 |
|---|
| 0.0 | |
|---|---|
| 1.0 | 513 |
| Value | Count | Frequency (%) | |
| 0.0 | 4487 | 89.7% | |
| 1.0 | 513 | 10.3% |
commutenonmotor
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.0584 |
|---|
| 0.0 | |
|---|---|
| 1.0 | 292 |
| Value | Count | Frequency (%) | |
| 0.0 | 4708 | 94.2% | |
| 1.0 | 292 | 5.8% |
commutepublic
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.0954 |
|---|
| 0.0 | |
|---|---|
| 1.0 | 477 |
| Value | Count | Frequency (%) | |
| 0.0 | 4523 | 90.5% | |
| 1.0 | 477 | 9.5% |
commuterail
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.2746 |
|---|
| 0.0 | |
|---|---|
| 1.0 |
| Value | Count | Frequency (%) | |
| 0.0 | 3627 | 72.5% | |
| 1.0 | 1373 | 27.5% |
commutetime
Numeric
| Distinct count | 30 |
|---|---|
| Unique (%) | 0.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 25.332 |
|---|---|
| Minimum | 13 |
| Maximum | 40.01 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 13 |
|---|---|
| 5-th percentile | 16 |
| Q1 | 21 |
| Median | 25 |
| Q3 | 29 |
| 95-th percentile | 35 |
| Maximum | 40.01 |
| Range | 27.01 |
| Interquartile range | 8 |
Descriptive statistics
| Standard deviation | 5.7542 |
|---|---|
| Coef of variation | 0.22715 |
| Kurtosis | -0.26483 |
| Mean | 25.332 |
| MAD | 4.6409 |
| Skewness | 0.23159 |
| Sum | 126660 |
| Variance | 33.111 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 24.0 | 336 | 6.7% | |
| 23.0 | 335 | 6.7% | |
| 27.0 | 331 | 6.6% | |
| 25.0 | 330 | 6.6% | |
| 22.0 | 325 | 6.5% | |
| 26.0 | 311 | 6.2% | |
| 21.0 | 307 | 6.1% | |
| 28.0 | 293 | 5.9% | |
| 29.0 | 260 | 5.2% | |
| 30.0 | 226 | 4.5% | |
| Other values (20) | 1946 | 38.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 13.0 | 72 | 1.4% | |
| 14.0 | 33 | 0.7% | |
| 15.0 | 84 | 1.7% | |
| 16.0 | 98 | 2.0% | |
| 17.0 | 130 | 2.6% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 37.0 | 39 | 0.8% | |
| 38.0 | 42 | 0.8% | |
| 39.0 | 31 | 0.6% | |
| 40.0 | 17 | 0.3% | |
| 40.01000000000022 | 50 | 1.0% |
commutewalk
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.3838 |
|---|
| 0.0 | |
|---|---|
| 1.0 |
| Value | Count | Frequency (%) | |
| 0.0 | 3081 | 61.6% | |
| 1.0 | 1919 | 38.4% |
confer
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.478 |
|---|
| 0.0 | |
|---|---|
| 1.0 |
| Value | Count | Frequency (%) | |
| 0.0 | 2610 | 52.2% | |
| 1.0 | 2390 | 47.8% |
creddebt
Numeric
| Distinct count | 4852 |
|---|---|
| Unique (%) | 97.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.7584 |
|---|---|
| Minimum | 0.03316 |
| Maximum | 14.28 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 0.03316 |
|---|---|
| 5-th percentile | 0.10109 |
| Q1 | 0.38552 |
| Median | 0.92644 |
| Q3 | 2.0638 |
| 95-th percentile | 6.373 |
| Maximum | 14.28 |
| Range | 14.247 |
| Interquartile range | 1.6783 |
Descriptive statistics
| Standard deviation | 2.3807 |
|---|---|
| Coef of variation | 1.3539 |
| Kurtosis | 10.45 |
| Mean | 1.7584 |
| MAD | 1.5277 |
| Skewness | 2.9733 |
| Sum | 8791.8 |
| Variance | 5.6676 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 14.280358400000008 | 50 | 1.0% | |
| 0.03316008 | 50 | 1.0% | |
| 0.23587200000000003 | 2 | 0.0% | |
| 0.532224 | 2 | 0.0% | |
| 0.37044 | 2 | 0.0% | |
| 0.31600799999999996 | 2 | 0.0% | |
| 0.658368 | 2 | 0.0% | |
| 1.36125 | 2 | 0.0% | |
| 0.4984199999999999 | 2 | 0.0% | |
| 0.129778 | 2 | 0.0% | |
| Other values (4842) | 4884 | 97.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.03316008 | 50 | 1.0% | |
| 0.033166 | 1 | 0.0% | |
| 0.03332000000000001 | 1 | 0.0% | |
| 0.033408 | 1 | 0.0% | |
| 0.03417600000000001 | 1 | 0.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 14.253551999999997 | 1 | 0.0% | |
| 14.25886 | 1 | 0.0% | |
| 14.267784 | 1 | 0.0% | |
| 14.28 | 1 | 0.0% | |
| 14.280358400000008 | 50 | 1.0% |
debtinc
Numeric
| Distinct count | 280 |
|---|---|
| Unique (%) | 5.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 9.9141 |
|---|---|
| Minimum | 0.7 |
| Maximum | 29.2 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 0.7 |
|---|---|
| 5-th percentile | 1.9 |
| Q1 | 5.1 |
| Median | 8.8 |
| Q3 | 13.6 |
| 95-th percentile | 22.2 |
| Maximum | 29.2 |
| Range | 28.5 |
| Interquartile range | 8.5 |
Descriptive statistics
| Standard deviation | 6.2417 |
|---|---|
| Coef of variation | 0.62958 |
| Kurtosis | 0.44555 |
| Mean | 9.9141 |
| MAD | 4.9702 |
| Skewness | 0.88787 |
| Sum | 49571 |
| Variance | 38.959 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 0.7000000000000001 | 54 | 1.1% | |
| 29.2 | 53 | 1.1% | |
| 7.000000000000001 | 48 | 1.0% | |
| 4.1000000000000005 | 46 | 0.9% | |
| 6.9 | 46 | 0.9% | |
| 5.4 | 45 | 0.9% | |
| 6.6000000000000005 | 42 | 0.8% | |
| 4.3999999999999995 | 42 | 0.8% | |
| 7.3 | 41 | 0.8% | |
| 11.3 | 39 | 0.8% | |
| Other values (270) | 4544 | 90.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.7000000000000001 | 54 | 1.1% | |
| 0.8 | 15 | 0.3% | |
| 0.8999999999999999 | 11 | 0.2% | |
| 1.0 | 10 | 0.2% | |
| 1.0999999999999999 | 18 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 28.7 | 2 | 0.0% | |
| 28.799999999999997 | 1 | 0.0% | |
| 28.9 | 2 | 0.0% | |
| 28.999999999999996 | 1 | 0.0% | |
| 29.2 | 53 | 1.1% |
default
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.2342 |
|---|
| 0.0 | |
|---|---|
| 1.0 |
| Value | Count | Frequency (%) | |
| 0.0 | 3829 | 76.6% | |
| 1.0 | 1171 | 23.4% |
ebill
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.3486 |
|---|
| 0.0 | |
|---|---|
| 1.0 |
| Value | Count | Frequency (%) | |
| 0.0 | 3257 | 65.1% | |
| 1.0 | 1743 | 34.9% |
ed
Numeric
| Distinct count | 14 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 14.544 |
|---|---|
| Minimum | 8 |
| Maximum | 21 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 8 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 12 |
| Median | 14 |
| Q3 | 17 |
| 95-th percentile | 20 |
| Maximum | 21 |
| Range | 13 |
| Interquartile range | 5 |
Descriptive statistics
| Standard deviation | 3.2426 |
|---|---|
| Coef of variation | 0.22294 |
| Kurtosis | -0.72614 |
| Mean | 14.544 |
| MAD | 2.6898 |
| Skewness | 0.0099514 |
| Sum | 72721 |
| Variance | 10.514 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 14.0 | 569 | 11.4% | |
| 15.0 | 536 | 10.7% | |
| 13.0 | 531 | 10.6% | |
| 16.0 | 486 | 9.7% | |
| 12.0 | 467 | 9.3% | |
| 17.0 | 454 | 9.1% | |
| 11.0 | 362 | 7.2% | |
| 18.0 | 349 | 7.0% | |
| 19.0 | 308 | 6.2% | |
| 10.0 | 260 | 5.2% | |
| Other values (4) | 678 | 13.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 8.0 | 146 | 2.9% | |
| 9.0 | 178 | 3.6% | |
| 10.0 | 260 | 5.2% | |
| 11.0 | 362 | 7.2% | |
| 12.0 | 467 | 9.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 17.0 | 454 | 9.1% | |
| 18.0 | 349 | 7.0% | |
| 19.0 | 308 | 6.2% | |
| 20.0 | 206 | 4.1% | |
| 21.0 | 148 | 3.0% |
edcat
Highly correlated
This variable is highly correlated with ed and should be ignored for analysis
| Correlation | 0.96649 |
|---|
empcat
Highly correlated
This variable is highly correlated with employ and should be ignored for analysis
| Correlation | 0.90359 |
|---|
employ
Numeric
| Distinct count | 40 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 9.698 |
|---|---|
| Minimum | 0 |
| Maximum | 39 |
| Zeros (%) | 13.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| Median | 7 |
| Q3 | 15 |
| 95-th percentile | 31 |
| Maximum | 39 |
| Range | 39 |
| Interquartile range | 13 |
Descriptive statistics
| Standard deviation | 9.5817 |
|---|---|
| Coef of variation | 0.98801 |
| Kurtosis | 0.71875 |
| Mean | 9.698 |
| MAD | 7.6253 |
| Skewness | 1.188 |
| Sum | 48490 |
| Variance | 91.809 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 0.0 | 659 | 13.2% | |
| 1.0 | 389 | 7.8% | |
| 2.0 | 318 | 6.4% | |
| 3.0 | 309 | 6.2% | |
| 4.0 | 293 | 5.9% | |
| 5.0 | 260 | 5.2% | |
| 6.0 | 250 | 5.0% | |
| 7.0 | 191 | 3.8% | |
| 8.0 | 187 | 3.7% | |
| 11.0 | 184 | 3.7% | |
| Other values (30) | 1960 | 39.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.0 | 659 | 13.2% | |
| 1.0 | 389 | 7.8% | |
| 2.0 | 318 | 6.4% | |
| 3.0 | 309 | 6.2% | |
| 4.0 | 293 | 5.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 35.0 | 22 | 0.4% | |
| 36.0 | 18 | 0.4% | |
| 37.0 | 17 | 0.3% | |
| 38.0 | 18 | 0.4% | |
| 39.0 | 55 | 1.1% |
equip
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.3408 |
|---|
| 0.0 | |
|---|---|
| 1.0 |
| Value | Count | Frequency (%) | |
| 0.0 | 3296 | 65.9% | |
| 1.0 | 1704 | 34.1% |
equipmon
Highly correlated
This variable is highly correlated with equip and should be ignored for analysis
| Correlation | 0.94719 |
|---|
equipten
Numeric
| Distinct count | 1634 |
|---|---|
| Unique (%) | 32.7% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 463.4 |
|---|---|
| Minimum | 0 |
| Maximum | 3679.5 |
| Zeros (%) | 65.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 510.16 |
| 95-th percentile | 2601 |
| Maximum | 3679.5 |
| Range | 3679.5 |
| Interquartile range | 510.16 |
Descriptive statistics
| Standard deviation | 882.83 |
|---|---|
| Coef of variation | 1.9051 |
| Kurtosis | 3.0986 |
| Mean | 463.4 |
| MAD | 654.48 |
| Skewness | 2.0084 |
| Sum | 2317000 |
| Variance | 779390 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 0.0 | 3296 | 65.9% | |
| 3679.4575 | 50 | 1.0% | |
| 2778.3 | 2 | 0.0% | |
| 1918.8 | 2 | 0.0% | |
| 2357.9 | 2 | 0.0% | |
| 206.7 | 2 | 0.0% | |
| 163.4 | 2 | 0.0% | |
| 446.45 | 2 | 0.0% | |
| 224.7 | 2 | 0.0% | |
| 101.05 | 2 | 0.0% | |
| Other values (1624) | 1638 | 32.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.0 | 3296 | 65.9% | |
| 12.05 | 1 | 0.0% | |
| 14.65 | 1 | 0.0% | |
| 14.85 | 1 | 0.0% | |
| 16.1 | 1 | 0.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3672.65 | 1 | 0.0% | |
| 3675.15 | 1 | 0.0% | |
| 3676.2 | 1 | 0.0% | |
| 3679.45 | 1 | 0.0% | |
| 3679.4575 | 50 | 1.0% |
forward
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.4806 |
|---|
| 0.0 | |
|---|---|
| 1.0 |
| Value | Count | Frequency (%) | |
| 0.0 | 2597 | 51.9% | |
| 1.0 | 2403 | 48.1% |
gender
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.5036 |
|---|
| 1.0 | |
|---|---|
| 0.0 |
| Value | Count | Frequency (%) | |
| 1.0 | 2518 | 50.4% | |
| 0.0 | 2482 | 49.6% |
homeown
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.6296 |
|---|
| 1.0 | |
|---|---|
| 0.0 |
| Value | Count | Frequency (%) | |
| 1.0 | 3148 | 63.0% | |
| 0.0 | 1852 | 37.0% |
hometype
Numeric
| Distinct count | 4 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.8426 |
|---|---|
| Minimum | 1 |
| Maximum | 4 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 2 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 4 |
| Range | 3 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 0.91673 |
|---|---|
| Coef of variation | 0.49752 |
| Kurtosis | -0.43415 |
| Mean | 1.8426 |
| MAD | 0.7634 |
| Skewness | 0.76947 |
| Sum | 9213 |
| Variance | 0.84039 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 1.0 | 2265 | 45.3% | |
| 2.0 | 1548 | 31.0% | |
| 3.0 | 896 | 17.9% | |
| 4.0 | 291 | 5.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.0 | 2265 | 45.3% | |
| 2.0 | 1548 | 31.0% | |
| 3.0 | 896 | 17.9% | |
| 4.0 | 291 | 5.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.0 | 2265 | 45.3% | |
| 2.0 | 1548 | 31.0% | |
| 3.0 | 896 | 17.9% | |
| 4.0 | 291 | 5.8% |
hourstv
Numeric
| Distinct count | 27 |
|---|---|
| Unique (%) | 0.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 19.627 |
|---|---|
| Minimum | 0 |
| Maximum | 31 |
| Zeros (%) | 1.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 17 |
| Median | 20 |
| Q3 | 23 |
| 95-th percentile | 28 |
| Maximum | 31 |
| Range | 31 |
| Interquartile range | 6 |
Descriptive statistics
| Standard deviation | 5.1192 |
|---|---|
| Coef of variation | 0.26083 |
| Kurtosis | 2.2956 |
| Mean | 19.627 |
| MAD | 3.8446 |
| Skewness | -0.72124 |
| Sum | 98133 |
| Variance | 26.206 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 20.0 | 451 | 9.0% | |
| 19.0 | 445 | 8.9% | |
| 21.0 | 440 | 8.8% | |
| 18.0 | 413 | 8.3% | |
| 22.0 | 371 | 7.4% | |
| 17.0 | 350 | 7.0% | |
| 16.0 | 309 | 6.2% | |
| 23.0 | 301 | 6.0% | |
| 15.0 | 263 | 5.3% | |
| 24.0 | 248 | 5.0% | |
| Other values (17) | 1409 | 28.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.0 | 85 | 1.7% | |
| 6.0 | 1 | 0.0% | |
| 7.0 | 3 | 0.1% | |
| 8.0 | 9 | 0.2% | |
| 9.0 | 13 | 0.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 27.0 | 127 | 2.5% | |
| 28.0 | 89 | 1.8% | |
| 29.0 | 73 | 1.5% | |
| 30.0 | 42 | 0.8% | |
| 31.0 | 66 | 1.3% |
inccat
Highly correlated
This variable is highly correlated with lninc and should be ignored for analysis
| Correlation | 0.95154 |
|---|
income
Numeric
| Distinct count | 223 |
|---|---|
| Unique (%) | 4.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 53.63 |
|---|---|
| Minimum | 9 |
| Maximum | 272.01 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 9 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 24 |
| Median | 38 |
| Q3 | 67 |
| 95-th percentile | 147 |
| Maximum | 272.01 |
| Range | 263.01 |
| Interquartile range | 43 |
Descriptive statistics
| Standard deviation | 46.568 |
|---|---|
| Coef of variation | 0.86832 |
| Kurtosis | 6.1931 |
| Mean | 53.63 |
| MAD | 32.56 |
| Skewness | 2.2674 |
| Sum | 268150 |
| Variance | 2168.6 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 22.0 | 112 | 2.2% | |
| 29.0 | 109 | 2.2% | |
| 25.0 | 108 | 2.2% | |
| 20.0 | 102 | 2.0% | |
| 30.0 | 102 | 2.0% | |
| 18.0 | 100 | 2.0% | |
| 23.0 | 100 | 2.0% | |
| 24.0 | 99 | 2.0% | |
| 32.0 | 93 | 1.9% | |
| 21.0 | 91 | 1.8% | |
| Other values (213) | 3984 | 79.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 9.0 | 83 | 1.7% | |
| 10.0 | 55 | 1.1% | |
| 11.0 | 57 | 1.1% | |
| 12.0 | 52 | 1.0% | |
| 13.0 | 56 | 1.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 257.0 | 2 | 0.0% | |
| 259.0 | 2 | 0.0% | |
| 261.0 | 3 | 0.1% | |
| 272.0 | 1 | 0.0% | |
| 272.0100000000002 | 50 | 1.0% |
internet
Numeric
| Distinct count | 5 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.1996 |
|---|---|
| Minimum | 0 |
| Maximum | 4 |
| Zeros (%) | 50.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 1 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 4 |
| Range | 4 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 1.4493 |
|---|---|
| Coef of variation | 1.2082 |
| Kurtosis | -0.83856 |
| Mean | 1.1996 |
| MAD | 1.2604 |
| Skewness | 0.80841 |
| Sum | 5998 |
| Variance | 2.1006 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 0.0 | 2498 | 50.0% | |
| 1.0 | 774 | 15.5% | |
| 3.0 | 598 | 12.0% | |
| 4.0 | 585 | 11.7% | |
| 2.0 | 545 | 10.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.0 | 2498 | 50.0% | |
| 1.0 | 774 | 15.5% | |
| 2.0 | 545 | 10.9% | |
| 3.0 | 598 | 12.0% | |
| 4.0 | 585 | 11.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 0.0 | 2498 | 50.0% | |
| 1.0 | 774 | 15.5% | |
| 2.0 | 545 | 10.9% | |
| 3.0 | 598 | 12.0% | |
| 4.0 | 585 | 11.7% |
jobcat
Numeric
| Distinct count | 6 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.7528 |
|---|---|
| Minimum | 1 |
| Maximum | 6 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 2 |
| Q3 | 4 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 5 |
| Interquartile range | 3 |
Descriptive statistics
| Standard deviation | 1.7379 |
|---|---|
| Coef of variation | 0.63132 |
| Kurtosis | -0.75877 |
| Mean | 2.7528 |
| MAD | 1.467 |
| Skewness | 0.79807 |
| Sum | 13764 |
| Variance | 3.0203 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 2.0 | 1640 | 32.8% | |
| 1.0 | 1388 | 27.8% | |
| 6.0 | 688 | 13.8% | |
| 3.0 | 620 | 12.4% | |
| 5.0 | 452 | 9.0% | |
| 4.0 | 212 | 4.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.0 | 1388 | 27.8% | |
| 2.0 | 1640 | 32.8% | |
| 3.0 | 620 | 12.4% | |
| 4.0 | 212 | 4.2% | |
| 5.0 | 452 | 9.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2.0 | 1640 | 32.8% | |
| 3.0 | 620 | 12.4% | |
| 4.0 | 212 | 4.2% | |
| 5.0 | 452 | 9.0% | |
| 6.0 | 688 | 13.8% |
jobsat
Numeric
| Distinct count | 5 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.9642 |
|---|---|
| Minimum | 1 |
| Maximum | 5 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| Median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 1.3795 |
|---|---|
| Coef of variation | 0.46537 |
| Kurtosis | -1.2367 |
| Mean | 2.9642 |
| MAD | 1.1637 |
| Skewness | 0.02675 |
| Sum | 14821 |
| Variance | 1.9029 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 3.0 | 1085 | 21.7% | |
| 2.0 | 1031 | 20.6% | |
| 4.0 | 1016 | 20.3% | |
| 1.0 | 975 | 19.5% | |
| 5.0 | 893 | 17.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.0 | 975 | 19.5% | |
| 2.0 | 1031 | 20.6% | |
| 3.0 | 1085 | 21.7% | |
| 4.0 | 1016 | 20.3% | |
| 5.0 | 893 | 17.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.0 | 975 | 19.5% | |
| 2.0 | 1031 | 20.6% | |
| 3.0 | 1085 | 21.7% | |
| 4.0 | 1016 | 20.3% | |
| 5.0 | 893 | 17.9% |
lncardmon
Highly correlated
This variable is highly correlated with callcard and should be ignored for analysis
| Correlation | 0.94918 |
|---|
lncardten
Highly correlated
This variable is highly correlated with lncardmon and should be ignored for analysis
| Correlation | 0.96006 |
|---|
lncreddebt
Highly correlated
This variable is highly correlated with creddebt and should be ignored for analysis
| Correlation | 0.92026 |
|---|
lnequipmon
Highly correlated
This variable is highly correlated with equipmon and should be ignored for analysis
| Correlation | 0.97195 |
|---|
lnequipten
Highly correlated
This variable is highly correlated with lnequipmon and should be ignored for analysis
| Correlation | 0.98331 |
|---|
lninc
Numeric
| Distinct count | 223 |
|---|---|
| Unique (%) | 4.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.697 |
|---|---|
| Minimum | 2.1972 |
| Maximum | 5.6058 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2.1972 |
|---|---|
| 5-th percentile | 2.5649 |
| Q1 | 3.1781 |
| Median | 3.6376 |
| Q3 | 4.2047 |
| 95-th percentile | 4.9904 |
| Maximum | 5.6058 |
| Range | 3.4086 |
| Interquartile range | 1.0266 |
Descriptive statistics
| Standard deviation | 0.7385 |
|---|---|
| Coef of variation | 0.19975 |
| Kurtosis | -0.32905 |
| Mean | 3.697 |
| MAD | 0.59837 |
| Skewness | 0.26668 |
| Sum | 18485 |
| Variance | 0.54538 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 3.091042453358316 | 112 | 2.2% | |
| 3.367295829986474 | 109 | 2.2% | |
| 3.2188758248682006 | 108 | 2.2% | |
| 2.995732273553991 | 102 | 2.0% | |
| 3.4011973816621555 | 102 | 2.0% | |
| 3.1354942159291497 | 100 | 2.0% | |
| 2.8903717578961645 | 100 | 2.0% | |
| 3.1780538303479458 | 99 | 2.0% | |
| 3.4657359027997265 | 93 | 1.9% | |
| 2.772588722239781 | 91 | 1.8% | |
| Other values (213) | 3984 | 79.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2.1972245773362196 | 83 | 1.7% | |
| 2.302585092994046 | 55 | 1.1% | |
| 2.3978952727983707 | 57 | 1.1% | |
| 2.4849066497880004 | 52 | 1.0% | |
| 2.5649493574615367 | 56 | 1.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 5.54907608489522 | 2 | 0.0% | |
| 5.556828061699537 | 2 | 0.0% | |
| 5.564520407322694 | 3 | 0.1% | |
| 5.605802066295998 | 1 | 0.0% | |
| 5.605838763584888 | 50 | 1.0% |
lnlongmon
Numeric
| Distinct count | 800 |
|---|---|
| Unique (%) | 16.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.2886 |
|---|---|
| Minimum | 0.61519 |
| Maximum | 4.1775 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 0.61519 |
|---|---|
| 5-th percentile | 1.0647 |
| Q1 | 1.7405 |
| Median | 2.2565 |
| Q3 | 2.8064 |
| 95-th percentile | 3.6043 |
| Maximum | 4.1775 |
| Range | 3.5623 |
| Interquartile range | 1.0659 |
Descriptive statistics
| Standard deviation | 0.76286 |
|---|---|
| Coef of variation | 0.33333 |
| Kurtosis | -0.35393 |
| Mean | 2.2886 |
| MAD | 0.61708 |
| Skewness | 0.16399 |
| Sum | 11443 |
| Variance | 0.58196 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 0.6151856390902335 | 51 | 1.0% | |
| 4.1774747946061055 | 50 | 1.0% | |
| 1.4350845252893227 | 31 | 0.6% | |
| 1.6094379124341003 | 29 | 0.6% | |
| 2.066862759472976 | 28 | 0.6% | |
| 1.7316555451583497 | 25 | 0.5% | |
| 2.0149030205422647 | 25 | 0.5% | |
| 1.6389967146756448 | 24 | 0.5% | |
| 1.3737155789130306 | 24 | 0.5% | |
| 1.55814461804655 | 24 | 0.5% | |
| Other values (790) | 4689 | 93.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.6151856390902335 | 51 | 1.0% | |
| 0.6418538861723947 | 6 | 0.1% | |
| 0.6678293725756554 | 8 | 0.2% | |
| 0.6931471805599453 | 5 | 0.1% | |
| 0.7178397931503168 | 13 | 0.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 4.1666652238017265 | 1 | 0.0% | |
| 4.167440117292651 | 1 | 0.0% | |
| 4.1751562049585145 | 1 | 0.0% | |
| 4.177459468932607 | 1 | 0.0% | |
| 4.1774747946061055 | 50 | 1.0% |
lnlongten
Highly correlated
This variable is highly correlated with lnlongmon and should be ignored for analysis
| Correlation | 0.92481 |
|---|
lnothdebt
Highly correlated
This variable is highly correlated with othdebt and should be ignored for analysis
| Correlation | 0.90163 |
|---|
lntollmon
Highly correlated
This variable is highly correlated with tollmon and should be ignored for analysis
| Correlation | 0.93703 |
|---|
lntollten
Highly correlated
This variable is highly correlated with lntollmon and should be ignored for analysis
| Correlation | 0.98558 |
|---|
lnwiremon
Highly correlated
This variable is highly correlated with wiremon and should be ignored for analysis
| Correlation | 0.95325 |
|---|
lnwireten
Highly correlated
This variable is highly correlated with lnwiremon and should be ignored for analysis
| Correlation | 0.98726 |
|---|
longmon
Numeric
| Distinct count | 800 |
|---|---|
| Unique (%) | 16.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 13.273 |
|---|---|
| Minimum | 1.85 |
| Maximum | 65.201 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1.85 |
|---|---|
| 5-th percentile | 2.9 |
| Q1 | 5.7 |
| Median | 9.55 |
| Q3 | 16.55 |
| 95-th percentile | 36.758 |
| Maximum | 65.201 |
| Range | 63.351 |
| Interquartile range | 10.85 |
Descriptive statistics
| Standard deviation | 11.552 |
|---|---|
| Coef of variation | 0.87034 |
| Kurtosis | 5.5676 |
| Mean | 13.273 |
| MAD | 8.1347 |
| Skewness | 2.1713 |
| Sum | 66363 |
| Variance | 133.44 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 1.85 | 51 | 1.0% | |
| 65.20100000000004 | 50 | 1.0% | |
| 4.2 | 31 | 0.6% | |
| 5.0 | 29 | 0.6% | |
| 7.9 | 28 | 0.6% | |
| 5.65 | 25 | 0.5% | |
| 7.5 | 25 | 0.5% | |
| 4.95 | 24 | 0.5% | |
| 5.15 | 24 | 0.5% | |
| 3.95 | 24 | 0.5% | |
| Other values (790) | 4689 | 93.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.85 | 51 | 1.0% | |
| 1.9 | 6 | 0.1% | |
| 1.95 | 8 | 0.2% | |
| 2.0 | 5 | 0.1% | |
| 2.05 | 13 | 0.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 64.5 | 1 | 0.0% | |
| 64.55 | 1 | 0.0% | |
| 65.05 | 1 | 0.0% | |
| 65.2 | 1 | 0.0% | |
| 65.20100000000004 | 50 | 1.0% |
longten
Highly correlated
This variable is highly correlated with longmon and should be ignored for analysis
| Correlation | 0.98281 |
|---|
marital
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.4802 |
|---|
| 0.0 | |
|---|---|
| 1.0 |
| Value | Count | Frequency (%) | |
| 0.0 | 2599 | 52.0% | |
| 1.0 | 2401 | 48.0% |
multline
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.4884 |
|---|
| 0.0 | |
|---|---|
| 1.0 |
| Value | Count | Frequency (%) | |
| 0.0 | 2558 | 51.2% | |
| 1.0 | 2442 | 48.8% |
news
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.4726 |
|---|
| 0.0 | |
|---|---|
| 1.0 |
| Value | Count | Frequency (%) | |
| 0.0 | 2637 | 52.7% | |
| 1.0 | 2363 | 47.3% |
othdebt
Numeric
| Distinct count | 4875 |
|---|---|
| Unique (%) | 97.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.5225 |
|---|---|
| Minimum | 0.1143 |
| Maximum | 24.064 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 0.1143 |
|---|---|
| 5-th percentile | 0.28769 |
| Q1 | 0.9803 |
| Median | 2.0985 |
| Q3 | 4.3148 |
| 95-th percentile | 11.816 |
| Maximum | 24.064 |
| Range | 23.95 |
| Interquartile range | 3.3345 |
Descriptive statistics
| Standard deviation | 4.2218 |
|---|---|
| Coef of variation | 1.1985 |
| Kurtosis | 8.4039 |
| Mean | 3.5225 |
| MAD | 2.7888 |
| Skewness | 2.686 |
| Sum | 17613 |
| Variance | 17.823 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 24.064260000000036 | 50 | 1.0% | |
| 0.11429903999999999 | 50 | 1.0% | |
| 1.112832 | 3 | 0.1% | |
| 0.9729720000000001 | 2 | 0.0% | |
| 0.355368 | 2 | 0.0% | |
| 0.531696 | 2 | 0.0% | |
| 0.18144 | 2 | 0.0% | |
| 1.131624 | 2 | 0.0% | |
| 1.84548 | 2 | 0.0% | |
| 2.9952 | 2 | 0.0% | |
| Other values (4865) | 4883 | 97.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.11429903999999999 | 50 | 1.0% | |
| 0.114312 | 1 | 0.0% | |
| 0.11438000000000004 | 1 | 0.0% | |
| 0.11668800000000001 | 1 | 0.0% | |
| 0.117936 | 1 | 0.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 23.841252 | 1 | 0.0% | |
| 23.892297 | 1 | 0.0% | |
| 23.95712 | 1 | 0.0% | |
| 24.062447999999996 | 1 | 0.0% | |
| 24.064260000000036 | 50 | 1.0% |
owncd
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.9328 |
|---|
| 1.0 | |
|---|---|
| 0.0 | 336 |
| Value | Count | Frequency (%) | |
| 1.0 | 4664 | 93.3% | |
| 0.0 | 336 | 6.7% |
owndvd
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.9136 |
|---|
| 1.0 | |
|---|---|
| 0.0 | 432 |
| Value | Count | Frequency (%) | |
| 1.0 | 4568 | 91.4% | |
| 0.0 | 432 | 8.6% |
ownfax
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.1788 |
|---|
| 0.0 | |
|---|---|
| 1.0 |
| Value | Count | Frequency (%) | |
| 0.0 | 4106 | 82.1% | |
| 1.0 | 894 | 17.9% |
owngame
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.4748 |
|---|
| 0.0 | |
|---|---|
| 1.0 |
| Value | Count | Frequency (%) | |
| 0.0 | 2626 | 52.5% | |
| 1.0 | 2374 | 47.5% |
ownipod
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.4792 |
|---|
| 0.0 | |
|---|---|
| 1.0 |
| Value | Count | Frequency (%) | |
| 0.0 | 2604 | 52.1% | |
| 1.0 | 2396 | 47.9% |
ownpc
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.6328 |
|---|
| 1.0 | |
|---|---|
| 0.0 |
| Value | Count | Frequency (%) | |
| 1.0 | 3164 | 63.3% | |
| 0.0 | 1836 | 36.7% |
ownpda
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.201 |
|---|
| 0.0 | |
|---|---|
| 1.0 |
| Value | Count | Frequency (%) | |
| 0.0 | 3995 | 79.9% | |
| 1.0 | 1005 | 20.1% |
owntv
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.983 |
|---|
| 1.0 | |
|---|---|
| 0.0 | 85 |
| Value | Count | Frequency (%) | |
| 1.0 | 4915 | 98.3% | |
| 0.0 | 85 | 1.7% |
ownvcr
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.9156 |
|---|
| 1.0 | |
|---|---|
| 0.0 | 422 |
| Value | Count | Frequency (%) | |
| 1.0 | 4578 | 91.6% | |
| 0.0 | 422 | 8.4% |
pager
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.2436 |
|---|
| 0.0 | |
|---|---|
| 1.0 |
| Value | Count | Frequency (%) | |
| 0.0 | 3782 | 75.6% | |
| 1.0 | 1218 | 24.4% |
pets
Numeric
| Distinct count | 14 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.0492 |
|---|---|
| Minimum | 0 |
| Maximum | 13 |
| Zeros (%) | 30.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 2 |
| Q3 | 5 |
| 95-th percentile | 10 |
| Maximum | 13 |
| Range | 13 |
| Interquartile range | 5 |
Descriptive statistics
| Standard deviation | 3.3512 |
|---|---|
| Coef of variation | 1.099 |
| Kurtosis | 0.22716 |
| Mean | 3.0492 |
| MAD | 2.7576 |
| Skewness | 1.0747 |
| Sum | 15246 |
| Variance | 11.231 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 0.0 | 1529 | 30.6% | |
| 1.0 | 780 | 15.6% | |
| 2.0 | 586 | 11.7% | |
| 3.0 | 376 | 7.5% | |
| 5.0 | 298 | 6.0% | |
| 4.0 | 284 | 5.7% | |
| 6.0 | 256 | 5.1% | |
| 7.0 | 246 | 4.9% | |
| 8.0 | 178 | 3.6% | |
| 9.0 | 170 | 3.4% | |
| Other values (4) | 297 | 5.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.0 | 1529 | 30.6% | |
| 1.0 | 780 | 15.6% | |
| 2.0 | 586 | 11.7% | |
| 3.0 | 376 | 7.5% | |
| 4.0 | 284 | 5.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 9.0 | 170 | 3.4% | |
| 10.0 | 115 | 2.3% | |
| 11.0 | 69 | 1.4% | |
| 12.0 | 50 | 1.0% | |
| 13.0 | 63 | 1.3% |
pets_birds
Numeric
| Distinct count | 4 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.106 |
|---|---|
| Minimum | 0 |
| Maximum | 3 |
| Zeros (%) | 94.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 3 |
| Range | 3 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.46261 |
|---|---|
| Coef of variation | 4.3642 |
| Kurtosis | 23.827 |
| Mean | 0.106 |
| MAD | 0.1992 |
| Skewness | 4.8348 |
| Sum | 530 |
| Variance | 0.21401 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 0.0 | 4698 | 94.0% | |
| 1.0 | 144 | 2.9% | |
| 2.0 | 88 | 1.8% | |
| 3.0 | 70 | 1.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.0 | 4698 | 94.0% | |
| 1.0 | 144 | 2.9% | |
| 2.0 | 88 | 1.8% | |
| 3.0 | 70 | 1.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 0.0 | 4698 | 94.0% | |
| 1.0 | 144 | 2.9% | |
| 2.0 | 88 | 1.8% | |
| 3.0 | 70 | 1.4% |
pets_cats
Numeric
| Distinct count | 4 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.4904 |
|---|---|
| Minimum | 0 |
| Maximum | 3 |
| Zeros (%) | 68.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 3 |
| Range | 3 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 0.82246 |
|---|---|
| Coef of variation | 1.6771 |
| Kurtosis | 1.654 |
| Mean | 0.4904 |
| MAD | 0.66949 |
| Skewness | 1.6148 |
| Sum | 2452 |
| Variance | 0.67644 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 0.0 | 3413 | 68.3% | |
| 1.0 | 923 | 18.5% | |
| 2.0 | 463 | 9.3% | |
| 3.0 | 201 | 4.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.0 | 3413 | 68.3% | |
| 1.0 | 923 | 18.5% | |
| 2.0 | 463 | 9.3% | |
| 3.0 | 201 | 4.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 0.0 | 3413 | 68.3% | |
| 1.0 | 923 | 18.5% | |
| 2.0 | 463 | 9.3% | |
| 3.0 | 201 | 4.0% |
pets_dogs
Numeric
| Distinct count | 4 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.3828 |
|---|---|
| Minimum | 0 |
| Maximum | 3 |
| Zeros (%) | 75.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 3 |
| Range | 3 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.75497 |
|---|---|
| Coef of variation | 1.9722 |
| Kurtosis | 3.2005 |
| Mean | 0.3828 |
| MAD | 0.57604 |
| Skewness | 2.0059 |
| Sum | 1914 |
| Variance | 0.56998 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 0.0 | 3762 | 75.2% | |
| 1.0 | 720 | 14.4% | |
| 2.0 | 360 | 7.2% | |
| 3.0 | 158 | 3.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.0 | 3762 | 75.2% | |
| 1.0 | 720 | 14.4% | |
| 2.0 | 360 | 7.2% | |
| 3.0 | 158 | 3.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 0.0 | 3762 | 75.2% | |
| 1.0 | 720 | 14.4% | |
| 2.0 | 360 | 7.2% | |
| 3.0 | 158 | 3.2% |
pets_freshfish
Numeric
| Distinct count | 12 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.8348 |
|---|---|
| Minimum | 0 |
| Maximum | 11 |
| Zeros (%) | 69.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 4 |
| 95-th percentile | 8 |
| Maximum | 11 |
| Range | 11 |
| Interquartile range | 4 |
Descriptive statistics
| Standard deviation | 3.0313 |
|---|---|
| Coef of variation | 1.6521 |
| Kurtosis | 0.56932 |
| Mean | 1.8348 |
| MAD | 2.5465 |
| Skewness | 1.3786 |
| Sum | 9174 |
| Variance | 9.1885 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 0.0 | 3462 | 69.2% | |
| 5.0 | 261 | 5.2% | |
| 6.0 | 251 | 5.0% | |
| 7.0 | 229 | 4.6% | |
| 4.0 | 222 | 4.4% | |
| 8.0 | 134 | 2.7% | |
| 3.0 | 130 | 2.6% | |
| 9.0 | 110 | 2.2% | |
| 11.0 | 67 | 1.3% | |
| 2.0 | 63 | 1.3% | |
| Other values (2) | 71 | 1.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.0 | 3462 | 69.2% | |
| 1.0 | 17 | 0.3% | |
| 2.0 | 63 | 1.3% | |
| 3.0 | 130 | 2.6% | |
| 4.0 | 222 | 4.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 7.0 | 229 | 4.6% | |
| 8.0 | 134 | 2.7% | |
| 9.0 | 110 | 2.2% | |
| 10.0 | 54 | 1.1% | |
| 11.0 | 67 | 1.3% |
pets_reptiles
Numeric
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.05 |
|---|---|
| Minimum | 0 |
| Maximum | 2 |
| Zeros (%) | 96.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 2 |
| Range | 2 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.27334 |
|---|---|
| Coef of variation | 5.4668 |
| Kurtosis | 35.606 |
| Mean | 0.05 |
| MAD | 0.09636 |
| Skewness | 5.8926 |
| Sum | 250 |
| Variance | 0.074715 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 0.0 | 4818 | 96.4% | |
| 1.0 | 114 | 2.3% | |
| 2.0 | 68 | 1.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.0 | 4818 | 96.4% | |
| 1.0 | 114 | 2.3% | |
| 2.0 | 68 | 1.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 0.0 | 4818 | 96.4% | |
| 1.0 | 114 | 2.3% | |
| 2.0 | 68 | 1.4% |
pets_saltfish
Numeric
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.0226 |
|---|---|
| Minimum | 0 |
| Maximum | 2 |
| Zeros (%) | 98.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 2 |
| Range | 2 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.21 |
|---|---|
| Coef of variation | 9.2918 |
| Kurtosis | 83.885 |
| Mean | 0.0226 |
| MAD | 0.044676 |
| Skewness | 9.2491 |
| Sum | 113 |
| Variance | 0.044098 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 0.0 | 4942 | 98.8% | |
| 2.0 | 55 | 1.1% | |
| 1.0 | 3 | 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.0 | 4942 | 98.8% | |
| 1.0 | 3 | 0.1% | |
| 2.0 | 55 | 1.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 0.0 | 4942 | 98.8% | |
| 1.0 | 3 | 0.1% | |
| 2.0 | 55 | 1.1% |
pets_small
Numeric
| Distinct count | 4 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.1028 |
|---|---|
| Minimum | 0 |
| Maximum | 3 |
| Zeros (%) | 95.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 3 |
| Range | 3 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.4832 |
|---|---|
| Coef of variation | 4.7004 |
| Kurtosis | 24.434 |
| Mean | 0.1028 |
| MAD | 0.19528 |
| Skewness | 4.9785 |
| Sum | 514 |
| Variance | 0.23348 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 0.0 | 4749 | 95.0% | |
| 3.0 | 90 | 1.8% | |
| 2.0 | 83 | 1.7% | |
| 1.0 | 78 | 1.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.0 | 4749 | 95.0% | |
| 1.0 | 78 | 1.6% | |
| 2.0 | 83 | 1.7% | |
| 3.0 | 90 | 1.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 0.0 | 4749 | 95.0% | |
| 1.0 | 78 | 1.6% | |
| 2.0 | 83 | 1.7% | |
| 3.0 | 90 | 1.8% |
polcontrib
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.2384 |
|---|
| 0.0 | |
|---|---|
| 1.0 |
| Value | Count | Frequency (%) | |
| 0.0 | 3808 | 76.2% | |
| 1.0 | 1192 | 23.8% |
polparty
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.3814 |
|---|
| 0.0 | |
|---|---|
| 1.0 |
| Value | Count | Frequency (%) | |
| 0.0 | 3093 | 61.9% | |
| 1.0 | 1907 | 38.1% |
polview
Numeric
| Distinct count | 7 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 4.0886 |
|---|---|
| Minimum | 1 |
| Maximum | 7 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 3 |
| Median | 4 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 1.3871 |
|---|---|
| Coef of variation | 0.33925 |
| Kurtosis | -0.5312 |
| Mean | 4.0886 |
| MAD | 1.0702 |
| Skewness | -0.19834 |
| Sum | 20443 |
| Variance | 1.9239 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 4.0 | 1733 | 34.7% | |
| 5.0 | 893 | 17.9% | |
| 6.0 | 843 | 16.9% | |
| 3.0 | 659 | 13.2% | |
| 2.0 | 623 | 12.5% | |
| 1.0 | 163 | 3.3% | |
| 7.0 | 86 | 1.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.0 | 163 | 3.3% | |
| 2.0 | 623 | 12.5% | |
| 3.0 | 659 | 13.2% | |
| 4.0 | 1733 | 34.7% | |
| 5.0 | 893 | 17.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3.0 | 659 | 13.2% | |
| 4.0 | 1733 | 34.7% | |
| 5.0 | 893 | 17.9% | |
| 6.0 | 843 | 16.9% | |
| 7.0 | 86 | 1.7% |
reason
Numeric
| Distinct count | 5 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 7.6368 |
|---|---|
| Minimum | 1 |
| Maximum | 9 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 9 |
| Median | 9 |
| Q3 | 9 |
| 95-th percentile | 9 |
| Maximum | 9 |
| Range | 8 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 2.85 |
|---|---|
| Coef of variation | 0.37319 |
| Kurtosis | 0.84805 |
| Mean | 7.6368 |
| MAD | 2.2095 |
| Skewness | -1.6586 |
| Sum | 38184 |
| Variance | 8.1225 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 9.0 | 4052 | 81.0% | |
| 1.0 | 447 | 8.9% | |
| 2.0 | 339 | 6.8% | |
| 4.0 | 105 | 2.1% | |
| 3.0 | 57 | 1.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.0 | 447 | 8.9% | |
| 2.0 | 339 | 6.8% | |
| 3.0 | 57 | 1.1% | |
| 4.0 | 105 | 2.1% | |
| 9.0 | 4052 | 81.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.0 | 447 | 8.9% | |
| 2.0 | 339 | 6.8% | |
| 3.0 | 57 | 1.1% | |
| 4.0 | 105 | 2.1% | |
| 9.0 | 4052 | 81.0% |
region
Numeric
| Distinct count | 5 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.0014 |
|---|---|
| Minimum | 1 |
| Maximum | 5 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| Median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 1.4218 |
|---|---|
| Coef of variation | 0.4737 |
| Kurtosis | -1.309 |
| Mean | 3.0014 |
| MAD | 1.2069 |
| Skewness | 0.0050525 |
| Sum | 15007 |
| Variance | 2.0214 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 5.0 | 1027 | 20.5% | |
| 1.0 | 1009 | 20.2% | |
| 3.0 | 1003 | 20.1% | |
| 2.0 | 995 | 19.9% | |
| 4.0 | 966 | 19.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.0 | 1009 | 20.2% | |
| 2.0 | 995 | 19.9% | |
| 3.0 | 1003 | 20.1% | |
| 4.0 | 966 | 19.3% | |
| 5.0 | 1027 | 20.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.0 | 1009 | 20.2% | |
| 2.0 | 995 | 19.9% | |
| 3.0 | 1003 | 20.1% | |
| 4.0 | 966 | 19.3% | |
| 5.0 | 1027 | 20.5% |
reside
Numeric
| Distinct count | 6 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.1942 |
|---|---|
| Minimum | 1 |
| Maximum | 6 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 2 |
| Q3 | 3 |
| 95-th percentile | 5 |
| Maximum | 6 |
| Range | 5 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 1.3615 |
|---|---|
| Coef of variation | 0.6205 |
| Kurtosis | 0.29171 |
| Mean | 2.1942 |
| MAD | 1.086 |
| Skewness | 1.0938 |
| Sum | 10971 |
| Variance | 1.8537 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 1.0 | 2035 | 40.7% | |
| 2.0 | 1467 | 29.3% | |
| 3.0 | 552 | 11.0% | |
| 4.0 | 521 | 10.4% | |
| 5.0 | 288 | 5.8% | |
| 6.0 | 137 | 2.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.0 | 2035 | 40.7% | |
| 2.0 | 1467 | 29.3% | |
| 3.0 | 552 | 11.0% | |
| 4.0 | 521 | 10.4% | |
| 5.0 | 288 | 5.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2.0 | 1467 | 29.3% | |
| 3.0 | 552 | 11.0% | |
| 4.0 | 521 | 10.4% | |
| 5.0 | 288 | 5.8% | |
| 6.0 | 137 | 2.7% |
response_01
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.0836 |
|---|
| 0.0 | |
|---|---|
| 1.0 | 418 |
| Value | Count | Frequency (%) | |
| 0.0 | 4582 | 91.6% | |
| 1.0 | 418 | 8.4% |
response_02
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.1298 |
|---|
| 0.0 | |
|---|---|
| 1.0 | 649 |
| Value | Count | Frequency (%) | |
| 0.0 | 4351 | 87.0% | |
| 1.0 | 649 | 13.0% |
response_03
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.1026 |
|---|
| 0.0 | |
|---|---|
| 1.0 | 513 |
| Value | Count | Frequency (%) | |
| 0.0 | 4487 | 89.7% | |
| 1.0 | 513 | 10.3% |
retire
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.1476 |
|---|
| 0.0 | |
|---|---|
| 1.0 | 738 |
| Value | Count | Frequency (%) | |
| 0.0 | 4262 | 85.2% | |
| 1.0 | 738 | 14.8% |
spoused
Highly correlated
This variable is highly correlated with marital and should be ignored for analysis
| Correlation | 0.95763 |
|---|
spousedcat
Highly correlated
This variable is highly correlated with spoused and should be ignored for analysis
| Correlation | 0.98315 |
|---|
telecommute
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.188 |
|---|
| 0.0 | |
|---|---|
| 1.0 |
| Value | Count | Frequency (%) | |
| 0.0 | 4060 | 81.2% | |
| 1.0 | 940 | 18.8% |
tenure
Numeric
| Distinct count | 72 |
|---|---|
| Unique (%) | 1.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 38.205 |
|---|---|
| Minimum | 1 |
| Maximum | 72 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 18 |
| Median | 38 |
| Q3 | 59 |
| 95-th percentile | 72 |
| Maximum | 72 |
| Range | 71 |
| Interquartile range | 41 |
Descriptive statistics
| Standard deviation | 22.661 |
|---|---|
| Coef of variation | 0.59313 |
| Kurtosis | -1.3307 |
| Mean | 38.205 |
| MAD | 19.914 |
| Skewness | -0.03621 |
| Sum | 191030 |
| Variance | 513.52 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 72.0 | 251 | 5.0% | |
| 71.0 | 147 | 2.9% | |
| 70.0 | 98 | 2.0% | |
| 69.0 | 94 | 1.9% | |
| 5.0 | 94 | 1.9% | |
| 9.0 | 88 | 1.8% | |
| 7.0 | 87 | 1.7% | |
| 2.0 | 81 | 1.6% | |
| 64.0 | 79 | 1.6% | |
| 11.0 | 79 | 1.6% | |
| Other values (62) | 3902 | 78.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.0 | 75 | 1.5% | |
| 2.0 | 81 | 1.6% | |
| 3.0 | 75 | 1.5% | |
| 4.0 | 71 | 1.4% | |
| 5.0 | 94 | 1.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 68.0 | 79 | 1.6% | |
| 69.0 | 94 | 1.9% | |
| 70.0 | 98 | 2.0% | |
| 71.0 | 147 | 2.9% | |
| 72.0 | 251 | 5.0% |
tollfree
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.4756 |
|---|
| 0.0 | |
|---|---|
| 1.0 |
| Value | Count | Frequency (%) | |
| 0.0 | 2622 | 52.4% | |
| 1.0 | 2378 | 47.6% |
tollmon
Numeric
| Distinct count | 197 |
|---|---|
| Unique (%) | 3.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 13.14 |
|---|---|
| Minimum | 0 |
| Maximum | 58.753 |
| Zeros (%) | 52.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 24.5 |
| 95-th percentile | 43.5 |
| Maximum | 58.753 |
| Range | 58.753 |
| Interquartile range | 24.5 |
Descriptive statistics
| Standard deviation | 15.811 |
|---|---|
| Coef of variation | 1.2033 |
| Kurtosis | -0.24916 |
| Mean | 13.14 |
| MAD | 13.856 |
| Skewness | 0.87308 |
| Sum | 65700 |
| Variance | 250 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 0.0 | 2622 | 52.4% | |
| 58.752500000000055 | 50 | 1.0% | |
| 22.75 | 33 | 0.7% | |
| 18.0 | 33 | 0.7% | |
| 24.0 | 32 | 0.6% | |
| 23.0 | 31 | 0.6% | |
| 23.75 | 30 | 0.6% | |
| 22.0 | 30 | 0.6% | |
| 20.0 | 29 | 0.6% | |
| 19.0 | 29 | 0.6% | |
| Other values (187) | 2081 | 41.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.0 | 2622 | 52.4% | |
| 8.0 | 1 | 0.0% | |
| 8.5 | 2 | 0.0% | |
| 8.75 | 2 | 0.0% | |
| 9.0 | 1 | 0.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 57.75 | 4 | 0.1% | |
| 58.0 | 3 | 0.1% | |
| 58.25 | 1 | 0.0% | |
| 58.75 | 3 | 0.1% | |
| 58.752500000000055 | 50 | 1.0% |
tollten
Numeric
| Distinct count | 2274 |
|---|---|
| Unique (%) | 45.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 570.13 |
|---|---|
| Minimum | 0 |
| Maximum | 3977.3 |
| Zeros (%) | 52.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 885.45 |
| 95-th percentile | 2620.2 |
| Maximum | 3977.3 |
| Range | 3977.3 |
| Interquartile range | 885.45 |
Descriptive statistics
| Standard deviation | 914.74 |
|---|---|
| Coef of variation | 1.6044 |
| Kurtosis | 2.7641 |
| Mean | 570.13 |
| MAD | 701.39 |
| Skewness | 1.824 |
| Sum | 2850700 |
| Variance | 836760 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 0.0 | 2622 | 52.4% | |
| 3977.270500000003 | 50 | 1.0% | |
| 10.0 | 3 | 0.1% | |
| 16.75 | 3 | 0.1% | |
| 1480.5 | 3 | 0.1% | |
| 763.75 | 2 | 0.0% | |
| 1727.75 | 2 | 0.0% | |
| 349.75 | 2 | 0.0% | |
| 1031.4 | 2 | 0.0% | |
| 732.3 | 2 | 0.0% | |
| Other values (2264) | 2309 | 46.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.0 | 2622 | 52.4% | |
| 8.75 | 1 | 0.0% | |
| 10.0 | 3 | 0.1% | |
| 10.5 | 1 | 0.0% | |
| 10.75 | 1 | 0.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3949.45 | 1 | 0.0% | |
| 3967.3 | 1 | 0.0% | |
| 3973.75 | 1 | 0.0% | |
| 3977.15 | 1 | 0.0% | |
| 3977.270500000003 | 50 | 1.0% |
total_benefit
Numeric
| Distinct count | 7 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 5.0398 |
|---|---|
| Minimum | 2 |
| Maximum | 8 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 4 |
| Median | 5 |
| Q3 | 6 |
| 95-th percentile | 8 |
| Maximum | 8 |
| Range | 6 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 1.5687 |
|---|---|
| Coef of variation | 0.31126 |
| Kurtosis | -0.64886 |
| Mean | 5.0398 |
| MAD | 1.2474 |
| Skewness | -0.0079873 |
| Sum | 25199 |
| Variance | 2.4607 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 5.0 | 1251 | 25.0% | |
| 6.0 | 978 | 19.6% | |
| 4.0 | 946 | 18.9% | |
| 7.0 | 615 | 12.3% | |
| 3.0 | 593 | 11.9% | |
| 8.0 | 329 | 6.6% | |
| 2.0 | 288 | 5.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2.0 | 288 | 5.8% | |
| 3.0 | 593 | 11.9% | |
| 4.0 | 946 | 18.9% | |
| 5.0 | 1251 | 25.0% | |
| 6.0 | 978 | 19.6% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 4.0 | 946 | 18.9% | |
| 5.0 | 1251 | 25.0% | |
| 6.0 | 978 | 19.6% | |
| 7.0 | 615 | 12.3% | |
| 8.0 | 329 | 6.6% |
total_fee
Numeric
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.377 |
|---|---|
| Minimum | 0 |
| Maximum | 2 |
| Zeros (%) | 65.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 2 |
| Range | 2 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 0.55365 |
|---|---|
| Coef of variation | 1.4686 |
| Kurtosis | 0.27771 |
| Mean | 0.377 |
| MAD | 0.49674 |
| Skewness | 1.1296 |
| Sum | 1885 |
| Variance | 0.30653 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 0.0 | 3294 | 65.9% | |
| 1.0 | 1527 | 30.5% | |
| 2.0 | 179 | 3.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.0 | 3294 | 65.9% | |
| 1.0 | 1527 | 30.5% | |
| 2.0 | 179 | 3.6% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 0.0 | 3294 | 65.9% | |
| 1.0 | 1527 | 30.5% | |
| 2.0 | 179 | 3.6% |
total_items
Numeric
| Distinct count | 29 |
|---|---|
| Unique (%) | 0.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 14.832 |
|---|---|
| Minimum | 2 |
| Maximum | 30 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 12 |
| Median | 15 |
| Q3 | 18 |
| 95-th percentile | 22 |
| Maximum | 30 |
| Range | 28 |
| Interquartile range | 6 |
Descriptive statistics
| Standard deviation | 4.3428 |
|---|---|
| Coef of variation | 0.2928 |
| Kurtosis | 0.06111 |
| Mean | 14.832 |
| MAD | 3.4409 |
| Skewness | 0.041318 |
| Sum | 74160 |
| Variance | 18.86 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 16.0 | 473 | 9.5% | |
| 15.0 | 470 | 9.4% | |
| 14.0 | 456 | 9.1% | |
| 13.0 | 411 | 8.2% | |
| 12.0 | 391 | 7.8% | |
| 17.0 | 384 | 7.7% | |
| 18.0 | 348 | 7.0% | |
| 11.0 | 330 | 6.6% | |
| 19.0 | 278 | 5.6% | |
| 10.0 | 246 | 4.9% | |
| Other values (19) | 1213 | 24.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2.0 | 10 | 0.2% | |
| 3.0 | 19 | 0.4% | |
| 4.0 | 30 | 0.6% | |
| 5.0 | 33 | 0.7% | |
| 6.0 | 43 | 0.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 26.0 | 24 | 0.5% | |
| 27.0 | 11 | 0.2% | |
| 28.0 | 2 | 0.0% | |
| 29.0 | 3 | 0.1% | |
| 30.0 | 2 | 0.0% |
total_spent
Numeric
| Distinct count | 4840 |
|---|---|
| Unique (%) | 96.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 6.0036 |
|---|---|
| Minimum | 3.7092 |
| Maximum | 7.5642 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 3.7092 |
|---|---|
| 5-th percentile | 4.8963 |
| Q1 | 5.6214 |
| Median | 6.0265 |
| Q3 | 6.4225 |
| 95-th percentile | 7.0407 |
| Maximum | 7.5642 |
| Range | 3.855 |
| Interquartile range | 0.80111 |
Descriptive statistics
| Standard deviation | 0.64474 |
|---|---|
| Coef of variation | 0.10739 |
| Kurtosis | 0.45687 |
| Mean | 6.0036 |
| MAD | 0.50167 |
| Skewness | -0.33839 |
| Sum | 30018 |
| Variance | 0.41569 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 3.709159908409081 | 12 | 0.2% | |
| 7.56420579828806 | 11 | 0.2% | |
| 5.926819353614451 | 3 | 0.1% | |
| 6.239027502962935 | 3 | 0.1% | |
| 6.070021536263528 | 3 | 0.1% | |
| 5.252221070655064 | 3 | 0.1% | |
| 6.413081836886114 | 3 | 0.1% | |
| 6.197624693381778 | 2 | 0.0% | |
| 5.607748699786767 | 2 | 0.0% | |
| 6.186949090428217 | 2 | 0.0% | |
| Other values (4830) | 4956 | 99.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 3.709159908409081 | 12 | 0.2% | |
| 3.8375149532530846 | 1 | 0.0% | |
| 3.895883460844997 | 1 | 0.0% | |
| 3.9154172384961616 | 1 | 0.0% | |
| 3.9189986191645714 | 1 | 0.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 7.513702264727489 | 1 | 0.0% | |
| 7.518205290233824 | 1 | 0.0% | |
| 7.518703411971194 | 1 | 0.0% | |
| 7.563283558802034 | 1 | 0.0% | |
| 7.56420579828806 | 11 | 0.2% |
total_tenure
Highly correlated
This variable is highly correlated with tenure and should be ignored for analysis
| Correlation | 0.92561 |
|---|
townsize
Numeric
| Distinct count | 5 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.6874 |
|---|---|
| Minimum | 1 |
| Maximum | 5 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range | 3 |
Descriptive statistics
| Standard deviation | 1.4262 |
|---|---|
| Coef of variation | 0.5307 |
| Kurtosis | -1.2632 |
| Mean | 2.6874 |
| MAD | 1.2581 |
| Skewness | 0.27659 |
| Sum | 13437 |
| Variance | 2.0341 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 1.0 | 1437 | 28.7% | |
| 2.0 | 1048 | 21.0% | |
| 3.0 | 907 | 18.1% | |
| 4.0 | 857 | 17.1% | |
| 5.0 | 751 | 15.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.0 | 1437 | 28.7% | |
| 2.0 | 1048 | 21.0% | |
| 3.0 | 907 | 18.1% | |
| 4.0 | 857 | 17.1% | |
| 5.0 | 751 | 15.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.0 | 1437 | 28.7% | |
| 2.0 | 1048 | 21.0% | |
| 3.0 | 907 | 18.1% | |
| 4.0 | 857 | 17.1% | |
| 5.0 | 751 | 15.0% |
union
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.1512 |
|---|
| 0.0 | |
|---|---|
| 1.0 | 756 |
| Value | Count | Frequency (%) | |
| 0.0 | 4244 | 84.9% | |
| 1.0 | 756 | 15.1% |
voice
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.303 |
|---|
| 0.0 | |
|---|---|
| 1.0 |
| Value | Count | Frequency (%) | |
| 0.0 | 3485 | 69.7% | |
| 1.0 | 1515 | 30.3% |
vote
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.518 |
|---|
| 1.0 | |
|---|---|
| 0.0 |
| Value | Count | Frequency (%) | |
| 1.0 | 2590 | 51.8% | |
| 0.0 | 2410 | 48.2% |
wireless
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Mean | 0.2688 |
|---|
| 0.0 | |
|---|---|
| 1.0 |
| Value | Count | Frequency (%) | |
| 0.0 | 3656 | 73.1% | |
| 1.0 | 1344 | 26.9% |
wiremon
Highly correlated
This variable is highly correlated with wireless and should be ignored for analysis
| Correlation | 0.91316 |
|---|
wireten
Numeric
| Distinct count | 1279 |
|---|---|
| Unique (%) | 25.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 409.96 |
|---|---|
| Minimum | 0 |
| Maximum | 4530.2 |
| Zeros (%) | 73.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 89.962 |
| 95-th percentile | 2687.9 |
| Maximum | 4530.2 |
| Range | 4530.2 |
| Interquartile range | 89.962 |
Descriptive statistics
| Standard deviation | 930.01 |
|---|---|
| Coef of variation | 2.2685 |
| Kurtosis | 6.1654 |
| Mean | 409.96 |
| MAD | 627.77 |
| Skewness | 2.5701 |
| Sum | 2049800 |
| Variance | 864910 |
| Memory size | 39.1 KiB |
| Value | Count | Frequency (%) | |
| 0.0 | 3656 | 73.1% | |
| 4530.186000000002 | 50 | 1.0% | |
| 2182.05 | 2 | 0.0% | |
| 2386.25 | 2 | 0.0% | |
| 2323.8 | 2 | 0.0% | |
| 1062.75 | 2 | 0.0% | |
| 2049.85 | 2 | 0.0% | |
| 1199.2 | 2 | 0.0% | |
| 20.9 | 2 | 0.0% | |
| 183.1 | 2 | 0.0% | |
| Other values (1269) | 1278 | 25.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.0 | 3656 | 73.1% | |
| 12.7 | 1 | 0.0% | |
| 14.55 | 1 | 0.0% | |
| 14.6 | 1 | 0.0% | |
| 14.9 | 2 | 0.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 4494.9 | 1 | 0.0% | |
| 4506.6 | 1 | 0.0% | |
| 4516.4 | 1 | 0.0% | |
| 4530.1 | 1 | 0.0% | |
| 4530.186000000002 | 50 | 1.0% |
Correlations
Sample
Multicollinearity¶
Since we can see that mant variables are highly correlated,thus we need to remove such variables¶
In [41]:
def func_corr(dataset,threshold=0.9,remove_negative_corr=False):
matrix_corr = dataset.corr()
#select whether to remove variables with negative high correlation
if remove_negative_corr:
matrix_corr=np.abs(matrix_corr)
#selecting upper triangle part of matrix
upper_tri = matrix_corr.where(np.triu(np.ones(matrix_corr.shape),k=1).astype(np.bool))
#get a list of columns with high correlation
col_highcorr = [column for column in upper_tri if any(upper_tri[column]>threshold)]
return col_highcorr
In [42]:
high_corr_list = func_corr(dataset.drop('total_spent',axis=1),threshold=0.9,remove_negative_corr=True)
In [43]:
dataset.drop(high_corr_list,axis=1,inplace=True)
In [44]:
all_columns = "+".join(dataset.columns.difference( ['total_spent'] ))
formula='total_spent~'+all_columns
lm=smf.ols(formula=formula,data=dataset).fit()
lm.summary()
Out[44]:
Normality¶
to check for normailty ,check whether the QQ plot is straight line or not¶
In [45]:
from scipy import stats
import pylab
stats.probplot( lm.resid, dist="norm", plot=pylab )
pylab.show()
Autocorrelation¶
Since in ols model summary Durbin-Watson stats value is 1.971 ~ 2 therefore, there is no autocorrelation.
In [46]:
def red_vif(df,threshold):
all_columns = "+".join(df.columns.difference( ['total_spent'] ))
my_formula = 'total_spent~'+all_columns
# VIF
from statsmodels.stats.outliers_influence import variance_inflation_factor
from patsy import dmatrices
y1, X1 = dmatrices(my_formula, df, return_type='dataframe')
# For each X1, calculate VIF and save in dataframe
vif = pd.DataFrame()
vif["VIF Factor"] = [variance_inflation_factor(X1.values, i) for i in range(X1.shape[1])]
vif["features"] = X1.columns
x=vif.sort_values(by = 'VIF Factor', ascending = False)
print(x)
print('___________________________________________________')
variable=list(x['features'])[1]
vif_val=list(x['VIF Factor'])[1]
if vif_val>threshold:
df.drop(variable,axis=1,inplace=True)
red_vif(df,threshold)
else:
return df
In [47]:
df=dataset
df1=red_vif(df,5)
In [48]:
dataset=df
In [49]:
all_columns = "+".join(df.columns.difference( ['total_spent'] ))
my_formula = "total_spent~" + all_columns
lm=smf.ols(formula = my_formula, data = dataset).fit()
lm.summary()
Out[49]:
Model Building¶
In [50]:
X=dataset.drop('total_spent',axis=1)
y=dataset.loc[:,'total_spent'].values
In [51]:
from sklearn.model_selection import train_test_split
X_train, X_test, y_train, y_test = train_test_split(X, y, test_size = 0.2, random_state = 0)
Drop variables with high p values¶
In [52]:
from sklearn.feature_selection import f_regression
In [53]:
F_values, p_values = f_regression( X_train, y_train )
In [54]:
li = [p for i,p in enumerate(p_values)]
In [55]:
len([i for i in li if i > 0.01])
Out[55]:
In [56]:
drop_index = [i for i,p in enumerate(p_values) if p>0.01]
drop_index
Out[56]:
In [57]:
dataset.drop(dataset.iloc[:,drop_index],axis=1,inplace=True)
In [58]:
dataset['total_spent']=y
In [59]:
dataset.columns
Out[59]:
In [60]:
dataset.shape
Out[60]:
In [61]:
X=dataset.drop('total_spent',axis=1)
y=dataset.loc[:,'total_spent'].values
from sklearn.model_selection import train_test_split
X_train, X_test, y_train, y_test = train_test_split(X, y, test_size = 0.2, random_state = 0)
Various types of Regression¶
- LinearRegression
- Lasso
- Ridge
- KNN
- SVM
- Decision Trees
- Random ForestIn [65]:
from sklearn.linear_model import LinearRegression
from sklearn.linear_model import Lasso
from sklearn.linear_model import Ridge
from sklearn.neighbors import KNeighborsRegressor
from sklearn.svm import SVR
from sklearn.tree import DecisionTreeRegressor
from sklearn.ensemble import RandomForestRegressor
from sklearn import metrics
In [63]:
models = []
models.append(('LR', LinearRegression()))
models.append(('LASSO', Lasso()))
models.append(('RIDGE', Ridge()))
models.append(('KNN', KNeighborsRegressor()))
models.append(('RandomForest',RandomForestRegressor()))
models.append(('CART', DecisionTreeRegressor()))
models.append(('SVR', SVR()))
In [66]:
from sklearn.model_selection import KFold
from sklearn.model_selection import cross_val_score
from sklearn.metrics import accuracy_score
# evaluate each model in turn
reg_result = []
model_name = []
score_mean = []
score_std = []
r2_score = []
num_folds=4
scoring='neg_mean_squared_error'
for name, model in models:
kfold = KFold(n_splits=num_folds, random_state=0)
cv_results = cross_val_score(model, X_train, y_train, cv=kfold, scoring=scoring)
reg=model.fit(X_train,y_train)
reg_r=reg.predict(X_test)
r2_score.append(metrics.r2_score(y_test,reg_r))
reg_result.append(cv_results)
model_name.append(name)
score_mean.append(cv_results.mean())
score_std.append(cv_results.std())
In [67]:
result_table =pd.DataFrame()
result_table['Model_name']=model_name
result_table['r2_score']=r2_score
result_table['Score_mean']=score_mean
result_table['Score std']=score_std
In [68]:
result_table.sort_values(by='r2_score',ascending=False)
Out[68]:
Since, RandomForest has best r2 score¶
- we will build model using RandomForestregressorRandomForest regression¶
In [69]:
rf=RandomForestRegressor()
rf.fit(X_train,y_train)
Out[69]:
In [71]:
# Training set
y_pred_train = rf.predict(X_train)
rmse_train = np.sqrt( metrics.mean_squared_error( y_train, y_pred_train) )
print(rmse_train)
print(metrics.r2_score( y_train, y_pred_train ))
In [72]:
# Test set
y_pred = rf.predict( X_test )
rmse = np.sqrt( metrics.mean_squared_error( y_test, y_pred ) )
print(rmse)
print(metrics.r2_score( y_test, y_pred ))
In [73]:
colnames=list(X.columns)
In [74]:
colvalues = list(rf.feature_importances_)
In [75]:
ce=pd.DataFrame({'names': colnames,
'coefficients': colvalues
})
In [76]:
print("RMSE ",rmse)
print("R2 metrics ",metrics.r2_score( y_test, y_pred ))
In [77]:
ce
Out[77]:
In [78]:
ce1 = ce.head(30)
ce1.coefficients.plot(kind='bar')
Out[78]:
